How to export Schema from Pluggable (PDB) using expdp utility in Oracle 18c Check the database status SQL> select INSTANCE_NAME, STATUS, VERSION from V$instance; INSTANCE_NAME    STATUS        VERSION —————————————— ora18c           OPEN         18.0.0.0.0 Check… Read more..

How to export the Pluggable full DB using expdp utility in Oracle 18c Check the database status SQL> select INSTANCE_NAME, STATUS, VERSION from V$instance; INSTANCE_NAME STATUS VERSION —————- ————————————— ora18c OPEN 18.0.0.0.0 Check the number of PDB’S exist in CDB [oracle@oracle18cdb… Read more..

How to export the Conatiner (CDB) Full DB using expdp utility in Oracle 18c Check the database status SQL> select INSTANCE_NAME, STATUS, VERSION from V$instance; INSTANCE_NAME   STATUS       VERSION ——————————————————— ora18c          OPEN         18.0.0.0.0 Create… Read more..

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..