Tuesday, November 28, 2023

ORA-02149: Specified partition does not exist

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

Popular Posts - All Times