impdp分区表约束违反后导致部分数据导入table_exists_action=truncate

2023-12-19 22:28:15

分区表只会truncate 一次，但是每个分区独立导入，单个分区的数据整体导入。不同分区的数据可以分别导入。

impdp ? ?directory= ?dumpfile= ??remap_schema= ?exclude=STATISTICS table_exists_action=truncate cluster=no parallel=4 tables=?

?Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported ? ?????0 KB ??????0 rows
. . imported ? ?????0 KB ??????0 rows
ORA-31693: ?failed to load/unload and is being skipped due to error:
ORA-29913: ?error in executing ODCIEXTTABLEFETCH callout
ORA-02290: ?Check violated

. . imported ??????0 KB ??????0 rows
. . imported ??????0 KB ??????0 rows
. . imported ??????0 KB ??????0 rows
. . imported ??????0 KB ??????0 rows
. . imported ??????0 KB ??????0 rows
. . imported ??????0 KB ??????0 rows
. . imported ??????0 KB ??????0 rows
. . imported ??????0 KB ??????0 rows
. . imported ??????0 KB ??????0 rows
. . imported ??????0 KB ??????0 rows
. . imported ??????0 KB ??????0 rows
. . imported ??????0 KB ??????0 rows
. . imported ??????0 KB ??????0 rows
. . imported ??????0 KB ??????0 rows
. . imported ??????0 KB ??????0 rows
. . imported ??????0 KB ??????0 rows
. . imported ??????0 KB ??????0 rows
. . imported ??????0 KB ??????0 rows
. . imported ??????0 KB ??????0 rows
. . imported ??????0 KB ??????0 rows
. . imported ??????0 KB ??????0 rows
. . imported ??????0 KB ??????0 rows
. . imported ??????0 KB ??????0 rows
. . imported ? ?????0 KB ??????0 rows
. . imported ??7.312 KB ??????5 rows
?

文章来源:https://blog.csdn.net/jnrjian/article/details/135090509
本文来自互联网用户投稿，该文观点仅代表作者本人，不代表本站立场。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。