impdp with SKIP_UNUSABLE_INDEXES returns with ORA-39326 cannot load data into table due to an unsuab
Oracle RDBMS 12.1.0.2
We quarterly refresh data from Prod to Dev and UAT with impdp on specific schemas.
I want to make the indexes unusable and then rebuild them after the import.
The indexes have a status of UNUSABLE, which is what I want.
The .par for the impdp has the line SKIP_UNUSABLE_INDEXES=Y, even though the default is Y, and the init.ora parameter skip_unusable_indexes is TRUE.
I get the error
ORA-39326: cannot load data into table due to an unusable index.
It used to be in earlier versions we'd drop the index, impdp, and then recreate the index. This seemed like a better option to me, and everything I find on using UNUSABLE for bulk loading with impdp is recommended.
1