This post is also available in:
Português
Sometimes, when your EXPDP takes so long (probably because you have huge partitioned tables), when you try to IMPDP somewhere later you may receive the error:
ORA-39083: Object type INDEX failed to create with error: ORA-14024: number of partitions of LOCAL index must equal that of the underlying table
This usually happens because the export of your table metadata was taken in a time before the index metadata. Even using the FLASHBACK_TIME won't cause you to have a consistent export because this clause is related to the SCN of the data only, not metadata.
To avoid this kind of problem, the best approach is to stop any user, job or scheduled activity that are creating new partitions or doing any kind of modifications in the structure of the objects that you are exporting. Also, if you have a Data Guard environment, you can temporarily stop the redp applying process and try to expdp from the standby.
Then you will have a consistent export and will not receive this error anymore when impdp.
Have you enjoyed? Please leave a comment or give a 👍!
