In today’s article, we will learn how we can create a Oracle Remap Table in three steps.
1. The table is exported from the first database.
2. Then “Dump File” is transferred to the database to be imported.
3. Finally, the table is transferred to a new database with a new name.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 |
$ impdp tables=SH.COUNTRIES remap_table=SH.COUNTRIES:ULKELER dumpfile=ulkeler.dmp; Import: Release 11.2.0.4.0 - Production on Tue Nov 18 15:33:35 2014 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Username: sys as sysdba Password: Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Oracle Label Security, OLAP, Data Mining, Oracle Database Vault and Real Application Testing options Master table "SYS"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded Starting "SYS"."SYS_IMPORT_TABLE_01": sys/******** AS SYSDBA tables=SH.COUNTRIES remap_table=SH.COUNTRIES:ULKELER dumpfile=ulkeler.dmp Processing object type TABLE_EXPORT/TABLE/TABLE Processing object type TABLE_EXPORT/TABLE/TABLE_DATA . . imported "SH"."ULKELER" 10.25 KB 24 rows Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object type TABLE_EXPORT/TABLE/COMMENT Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX ORA-31684: Object type INDEX:"SH"."COUNTRIES_PK" already exists Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT ORA-31684: Object type CONSTRAINT:"SH"."COUNTRIES_PK" already exists Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS ORA-39111: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"SH"."COUNTRIES_PK" already exists Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Job "SYS"."SYS_IMPORT_TABLE_01" completed with 3 error(s) at Tue Nov 18 15:33:46 2014 elapsed 0 00:00:02 |
