Shulou(Shulou.com)06/01 Report--

The business requires the establishment of a unique index, and the unique index also has a ⊙ judgment (⊙ judgment ⊙), so it may also bring a little problem to the program itself (⊙ judgment ⊙).

Create unique index DMP_CORE_BASE.u_project_model_hv_bid_c on DMP_CORE_BASE.project_model (decode (history_version,0,code,id), biz_id) tablespace DMP_CORE_BASE online

To consider the problems caused by the virtual column, develop the initialization program over there

For example, the following one brings problems.

Create unique index COUPON_CORE_BASE_KK.U_CPCO_GROUP_COUPON_IT_GID_RID on COUPON_CORE_BASE_KK.CPCO_GROUP_COUPON_ITEM (NVL (RECEIVE_ROLE_ID,ID), GROUP_COUPON_ID) tablespace COUPON_CORE_BASE_KK

The final solution is to delete it first and wait for the business initialization to be established.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.