Datapump Import with sqlerrm = ORA-20000: Unable to set values for index: does not exist or insufficient privileges

ORA-20000: Unable to set values for index<Index_Name>:

Issue :

We are migrating a Oracle Legacy On-prom DB from version 12c to AWS RDS Oracle DB Version 19c with datapump IMPDP and EXPDP method.

While importing we found the below error message in the oracle db impdp log file.


This is a known problem while export/import Oracle Database and the few workaround are given below.

  1. Exclude statistics, and the EXEC DBMS_STATS.gather_schema_stats in the target database.

SQL> EXEC DBMS_STATS.gather_schema_stats(ownname =>’SCHEMA01′, estimate_percent => 100);
PL/SQL procedure successfully completed.

2. Oracle recommends not to export the statistics with Oracle datapump or use Or import exclude=statistics during the import datapump.

2. impdp username/password@dbname exclude=statistics dumpfile=dump_file_name1.dmp logfile=log_file_name_1.log schemas=SCHEMA1

Job “SYSTEM”.”SYS_IMPORT_SCHEMA_01″ successfully completed at Fri Jan 4 00:32:00 2023 elapsed 0 00:01:01

* End of Document *

You may also like...