Problem
Importing data into an Oracle Database 19c with impdp fails with the errors like:
ORA-31693: Table data object <table> failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-14401: inserted partition key is outside specified partition
The table is an interval-range-partitioned table
Solution
Use the DATA_OPTIONS=DISABLE_APPEND_HINT option of impdp
No comments:
Post a Comment