Oracle 18c Datapump-Include Parameter
Description:-
- In this article we are going to see the Oracle 18c Datapump-Include Parameter
Let start the demo:-
Demo1:-include emp table
[oracle@testdb ~]$ sqlplus hari/hari@pdb1
SQL*Plus: Release 18.0.0.0.0 Production on Sat Jul 14 17:02:53 2018
Version 18.1.0.0.0
Copyright (c) 1982, 2017, Oracle. All rights reserved.
Last Successful login time: Sat Jul 14 2018 16:09:44 +00:00
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.1.0.0.0
SQL> select tname from tab;
TNAME
--------------------------
CHENNAI
DEPT
EMP
HR
INDIA
SALES
SAM
SYS_EXPORT_SCHEMA_01
8 rows selected.
[oracle@testdb ~]$ expdp system/Chennai#123@pdb1 schemas=hari include=TABLE:\"= \'EMP\'\" directory=test_dir dumpfile=include.dmp logfile=include.log
Export: Release 18.0.0.0.0 - Production on Sat Jul 14 18:47:18 2018
Version 18.1.0.0.0
Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/********@pdb1 schemas=hari include=TABLE:"= 'EMP'" directory=test_dir dumpfile=include.dmp logfile=include.log
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/TABLE
. . exported "HARI"."EMP" 17.08 KB 107 rows
Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:
/u01/app/oracle/datapump/include.dmp
Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at Sat Jul 14 18:47:39 2018 elapsed 0 00:00:19
Demo2:-using parfile
[oracle@testdb ~]$ cat expdp_exclude.par
DIRECTORY=test_dir
DUMPFILE=emp2.dmp
LOGFILE=emp2.log
schemas=hari
INCLUDE=TABLE:"IN ('EMP','DEPT')"
[oracle@testdb ~]$ expdp system/Chennai#123@pdb1 parfile=expdp_exclude.par
Export: Release 18.0.0.0.0 - Production on Sun Jul 15 02:57:15 2018
Version 18.1.0.0.0
Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/********@pdb1 parfile=expdp_exclude.par
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/TABLE
. . exported "HARI"."DEPT" 17.08 KB 107 rows
. . exported "HARI"."EMP" 17.08 KB 107 rows
Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:
/u01/app/oracle/datapump/emp2.dmp
Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at Sun Jul 15 02:57:42 2018 elapsed 0 00:00:26
Catch Me On:- Hariprasath Rajaram
LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter Group:https://www.linkedin.com/groups/10387079 Twitter: https://twitter.com/hariprasathdba