How to import the table by using the impdp in Oracle Database 11gR2(11.2.0.4) In this scenario, I am going to import at the table “test1” in schema “MIRTEST” from the given dumpfile Create a directory at OS Level [oracle@testdb ~]$ mkdir -p /u01/dump/ Give the permisssion for directory & verify… Read more..

How to import the Schema by using the impdp in Oracle Database 11gR2(11.2.0.4) In the below scenario, I am going to perform the import of the schema “MIRTEST” from the dumpfile Create a directory at OS Level [oracle@testdb ~]$ mkdir -p /u01/dump/ Give the permisssion for directory & verify the Ownership

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

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