SQL & PL/SQL

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!

Is there a way to avoid corrupted indexes after running SQL Loader?

simon87Jan 21 2021 — edited Jan 21 2021

I have this Oracle versión:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit
After running a load with repeated data on the single-indexed column, the index becomes corrupted. How could you validate the index in the SQL Loader? to prevent it from corrupting the index.

Thank you :)

Added on Jan 21 2021

#error, #index, #sql, #table

1 comment

510 views