export the specific table partitions using expdp

Production Server
=================
expdp hr/hr@orcl tables=TEST1:P2013_7,TEST2:P2013_7 directory=DB_DUMP dumpfile=exp_testcdr_P2013_7.dmp

-bash-3.2$ expdp hr/hr@orcl tables=TEST1:P2013_7,TEST2:P2013_7 directory=DB_DUMP dumpfile=exp_testcdr_P2013_7.dmp

Export: Release 11.2.0.3.0 – Production on Thu Aug 22 11:09:13 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Starting “hr”.”SYS_EXPORT_TABLE_01″: hr/********@orcl tables=TEST1:P2013_7,TEST2:P2013_7 directory=DB_DUMP dumpfile=exp_testcdr_P2013_7.dmp
Estimate in progress using BLOCKS method…
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 256 MB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
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
. . exported “hr”.”TEST1″:”P2013_7″ 142.5 MB 370614 rows
. . exported “hr”.”TEST2″:”P2013_7″ 116.6 KB 159 rows
Master table “hr”.”SYS_EXPORT_TABLE_01″ successfully loaded/unloaded
******************************************************************************
Dump file set for hr.SYS_EXPORT_TABLE_01 is:
/backup/datapump/exp_testcdr_P2013_7.dmp
Job “hr”.”SYS_EXPORT_TABLE_01″ successfully completed at 11:09:25

Testbed-QA Server
==================
first of all just create table TEST1 and TEST2

[oracle@QA dpdump]$ impdp scott/scott directory=DB_DUMP dumpfile=exp_testcdr_P2013_7.dmp remap_schema=hr:scott table_exists_action=append

Import: Release 11.2.0.1.0 – Production on Thu Aug 22 13:36:38 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table “scott”.”SYS_IMPORT_FULL_01″ successfully loaded/unloaded
Starting “scott”.”SYS_IMPORT_FULL_01″: scott/******** directory=DB_DUMP_scott dumpfile=exp_testcdr_P2013_7.dmp remap_schema=hr:scott table_exists_action=append
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-39152: Table “scott”.”TEST1” exists. Data will be appended to existing table but all dependent metadata will be skipped due to table_exists_action of append
ORA-39152: Table “scott”.”TEST2” exists. Data will be appended to existing table but all dependent metadata will be skipped due to table_exists_action of append
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported “scott”.”TEST1”:”P2013_7″ 142.5 MB 370614 rows
. . imported “scott”.”TEST2”:”P2013_7″ 116.6 KB 159 rows
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
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 “scott”.”SYS_IMPORT_FULL_01″ completed with 2 error(s) at 13:37:01

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.