How to export schema with Parallel method by using expdp [oracle@testdb dump_bkp]$ expdp system directory=dump_bkp dumpfile=expdp%U-`date ‘+%d%m%Y_%H%M%S’`.dmp logfile=expdp-`date ‘+%d%m%Y_%H%M%S’`.log schemas=mir PARALLEL=2 Export: Release 11.2.0.4.0 – Production on Sat Oct 13 15:25:00 2018 Copyright (c) 1982, 2011, Oracle and/or… Read more..

How to exclude Single or Multiple tables from schema by using from EXPDP Include Single table from schema [oracle@testdb dump_bkp]$ expdp system directory=dump_bkp dumpfile=mir04sep18.dmp logfile=mir04sep18.log schemas=mir include=TABLE:”IN(‘T1’)” Export: Release 11.2.0.4.0 – Production on Tue Sep 4 11:16:31 2018 Copyright… Read more..

How to export partition table by using expdp  Consider the below example tested in our test env & verified Create the directory at OS Level to place the backup of the dumpfile [oracle@testdb backup]$ mkdir db_dump_bkp [root@testdb backup]#… Read more..

How to export schema with compression method by using expdp Consider the below example tested in our test env & verified Create the directory at OS Level to place the backup of the dumpfile [oracle@testdb backup]$ mkdir db_dump_bkp [root@testdb backup]# chmod -R 777 db_dump_bkp/ Create… Read more..

How to export full database level by using expdp Consider the below example tested in our test env & verified Create the directory at OS Level to place the backup of the dumpfile [oracle@testdb backup]$ mkdir db_dump_bkp [root@testdb backup]# chmod -R 777 db_dump_bkp/ Create… Read more..

How to export schema level by using expdp Consider the below example tested in our test env & verified Create the directory at OS Level to place the backup of the dumpfile [oracle@testdb backup]$ mkdir db_dump_bkp [root@testdb backup]# chmod -R 777 db_dump_bkp/ Create… Read more..