Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Use of functional index in a unicode 12.2 enterprise stand alone database

user11988334Dec 20 2019

SQL query i staking forever to run and not loading at all. Using a parallelism of 4, I am able to make it load but when I run OEM adviser, it is suggesting a functional index that already exists. When I go to create the suggested index anyway, it says it already exists.

Index it is suggesting:

pastedImage_0.png

Index that already exists: generated a DDL for existing index one.

CREATE UNIQUE INDEX "BAAN"."TTCIBD001100$IDX1" ON "BAAN"."TTCIBD001100" (NLSSORT("T$ITEM",'nls_sort=''UCA0700_DUCET_S4_VS_BN_NY_EN_FN_HN_DN_MN''')) TABLESPACE "LN100_INDEX" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) NOLOGGING

Any help would be greatly appreciated.
Comments
Post Details
Added on Dec 20 2019
#database-key-features, #database-migration-assistant-for-unicode
0 comments
175 views