If you are performing a datapump export and you are returned following error for one or more tables, this means that probably a simultaneous partition maintenance operation is in progress during this time this table was accessed for export. ORA-31693, ORA-02354, ORA-02149
ORA-31693: Table data object "<TABLE_OWNER>."<TABLE_NAME>":"<PARTITION_NAME>" failed to load/unload and is being skipped due to error: ORA-02354: error in exporting/importing data ORA-02149: Specified partition does not exist |
In above case, we had a scheduled job running at the same time to purge old partitions of the table and during an export at the same time, this partition was being dropped and hence became inaccessible for the expdp.
No comments:
Post a Comment