因客户删除数据,恢复表时发现恢复表后发现比原表多了100多行,啥原因暂不清楚,继续学习
[oracle@hydb ~]$ more expdp_orcl_20240406_2100.log |grep '"USR_HY"."T_COPIES"'
. . exported "USR_HY"."T_COPIES" 1.446 MB 80836 rows
[oracle@hydb ~]$ impdp system/"********" directory=dir_dump dumpfile=orcl_20240506_2100_%U.dmp logfile=impdp_T_COPIES.log tables=USR_HY.T_COPIES remap_table=USR_HY.T_COPIES:T_COPIES20240506 transform=oid:n
Import: Release 11.2.0.4.0 - Production on Wed May 8 11:24:39 2024
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_TABLE_01": directory=dir_dump dumpfile=orcl_20240506_2100_%U.dmp logfile=impdp_T_SP_FREE_COPIES.log tables=USR_HY.T_SP_FREE_COPIES remap_table=USR_HY.T_SP_FREE_COPIES:T_SP_FREE_COPIES2024050621 transform=oid:n
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "USR_HY"."T_SP_FREE_COPIES20240506" 1.470 MB 81795 rows
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
ORA-31684: Object type INDEX:"USR_HY"."USER_ID_ITEM_ID" already exists
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
ORA-31684: Object type CONSTRAINT:"USR_HY"."USER_ID_ITEM_ID" already exists
ORA-31684: Object type CONSTRAINT:"USR_HY"."SYS_C00441047" already exists
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
ORA-39111: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"USR_HY"."USER_ID_ITEM_ID" already exists
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "SYSTEM"."SYS_IMPORT_TABLE_01" completed with 4 error(s) at Wed May 8 11:24:54 2024 elapsed 0 00:00:14