I have a unique index in which I need to load 800,000 rows.
I changed the index and made it unuseable. I have added the 'Options (Rows = 4000, Bindshies = 512000, Skip_Assassible_indexS = TRUE)' in my control file.
I still get the form errors:
ORA-01502: The index 'x_Unique' or the division of such index is in a bad state
suggestions are welcome
You can not do it with a unique index. See:
However, the indexes which are unique and marked IUs are not allowed to release index maintenance. This rule has been implemented by DML operations and has been implemented by direct route load to suit DML.
You probably should leave your index and recreate it later.
No comments:
Post a Comment