Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Java.lang.IllegalArgumentException:There is no column named SYS_NC00010 $

2025-04-03 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report