Posted by Mir Sayeed Hassan on 25th July 2020
How to export the data of 1 week by using the expdp in Oracle database 11gR2(11.2.0.4) To perform this 1 week of export of data between the given date, fallow the below procedure. CREATE A DIRECTORY AT OS LEVEL [oracle@testdb_new backup]$ mkdir dumpbkp CREATE A DIRECTORY AT DB LEVEL SQL> create directory… Read more..
Posted in Datapump (Expdp/Impdp) | Comments Off on How to export the data of 1 week by using the expdp in Oracle database 11gR2(11.2.0.4)
Posted by Mir Sayeed Hassan on 23rd June 2019
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..
Posted in Datapump (Expdp/Impdp) | Comments Off on How to export Schema from Pluggable (PDB) using expdp utility in Oracle 18c
Posted by Mir Sayeed Hassan on 23rd June 2019
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..
Posted in Datapump (Expdp/Impdp) | Comments Off on How to export the Pluggable full DB using expdp utility in Oracle 18c
Posted by Mir Sayeed Hassan on 23rd June 2019
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..
Posted in Datapump (Expdp/Impdp) | Comments Off on How to export the Conatiner (CDB) Full DB using expdp utility in Oracle 18c
Posted by Mir Sayeed Hassan on 13th October 2018
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..
Posted in Datapump (Expdp/Impdp) | Comments Off on How to export schema with Parallel method by using expdp
Posted by Mir Sayeed Hassan on 4th September 2018
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..
Posted in Datapump (Expdp/Impdp) | Comments Off on How to exclude Single or Multiple tables from schema by using from EXPDP
