龙浩lh40 发表于 2012-01-17 09:50

使用IMPDP命令时报一个错误,但是数据确实已经导进去,求高手帮助!!!!

下面是我做测试的全过程:
执行的命令是:impdp aa/aa dumpfile=exp.dmp table_exists_action=TRUNCATE

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "AA"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "AA"."SYS_IMPORT_FULL_01":aa/******** dumpfile=exp.dmp table_exis
ts_action=TRUNCATE
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-39153: Table "AA"."AA_FILE" exists and has been truncated. Data will be
loaded but all dependent metadata will be skipped due to table_exists_action of
truncate
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "AA"."AA_FILE"                        50.72 KB      66 rows
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "AA"."SYS_IMPORT_FULL_01" completed with 1 error(s) at 09:42:01


请问这个到底是什么错误,而且我检查过,数据已经完全导进去了~~~~~~~~~

renxiao2003 发表于 2012-01-17 13:00

你的导入用户是不是已经有数据了。

龙浩lh40 发表于 2012-01-17 19:23

回复 2# renxiao2003
用户?你是想问那个表么?是的~~~但是我已经选择table_exists_action=TRUNCATE参数了呀



   

renxiao2003 发表于 2012-01-17 22:43

所以你的问题出现是正常的啊。
页: [1]
查看完整版本: 使用IMPDP命令时报一个错误,但是数据确实已经导进去,求高手帮助!!!!