Thursday 15 July 2010

oracle - SQLLDR and skip_unusable_indexes -


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