Powered By Blogger

Wednesday, January 26, 2011

Table Level Import by replacing statistics

table import
-------------------

[nvar@insiscdev01 Navan]$ impdp system/nvar@nvarTMP DIRECTORY=EXP_DMP DUMPFILE=expdp_nvar4_TMP_22Apr10.dmp tables=nvartxn.REPORT_GROUP remap_schema=nvartxn:nvartxn TABLE_EXISTS_ACTION=replace

Import: Release 11.1.0.6.0 - Production on Friday, 23 April, 2010 0:42:22
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded
nvarting "SYSTEM"."SYS_IMPORT_TABLE_01": system/********@nvarTMP DIRECTORY=EXP_DMP DUMPFILE=expdp_nvar4_TMP_22Apr10.dmp tables=nvartxn.REPORT_GROUP remap_schema=nvartxn:nvartxn TABLE_EXISTS_ACTION=replace
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "nvarTXN"."REPORT_GROUP" 14.16 KB 46 rows
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Job "SYSTEM"."SYS_IMPORT_TABLE_01" successfully completed at 00:42:27

import schemas from dump
------------------------------

[nvar@insiscdev01 Navan]$ impdp system/nvar@nvarTMP DIRECTORY=EXP_DMP DUMPFILE=expdp_nvar4_TST_22Apr10.dmp remap_schema=nvartxn:nvartxn,nvarrep:nvarrep,nvartxnapp:nvartxnapp,nvarrepapp:nvarrepapp,nvarmig:nvarmig logfile=impdp_nvar4_TMP_22Apr10.log

No comments:

Post a Comment