_backup dumpfile=newdb.dmp logfile=newdb.log parallel=4 content=all full=y cluster=n
. . imported "H1"."TRDX_OC" 5.950 MB 60692 rows . . imported "H1"."TRDX_Q" 4.643 MB 15728 rows ORA-31693: Table data object "H1"."TRDX_P" failed to load/unload and is being skipped due to error: ORA-02354: error in exporting/importing data ORA-12081: update operation not allowed on table "H1"."TRDX_P" . . imported "H1"."TRDX_QU" 5.687 MB 18639 rows ORA-31693: Table data object "H1"."TRDX_HL" failed to load/unload and is being skipped due to error: ORA-02354: error in exporting/importing data ORA-12081: update operation not allowed on table "H1"."TRDX_HLD" . . imported "H1"."TRDX_API_TX" 5.079 MB 48360 rows . . imported "H1"."TRDX_DE" 4.361 MB 91505 rows ORA-31693: Table data object "H1"."TRDX_ASSE" failed to load/unload and is being skipped due to error: ORA-02354: error in exporting/importing data ORA-12081: update operation not allowed on table "H1"."TRDX_ASSET"
导入的同时出现以上错误，根据Mos [Doc 1270847.1]描述是由于这些表上存在物化视图，建议使用TABLE_EXISTS_ACTION=APPEND参数导入数据； 此参数默认是SKIP。
|