Export Dumpfile error with ORA-31617: unable to open dump file for write in RAC Database Error occur while performing the Schema export in RAC Database. Error Occur. ORA-31693: Table data object “PRG1″.”IRM”:”P1575″ failed to load/unload and is being skipped due to error: ORA-31617: unable to open dump file “/SWITCHBKP/DUMPBKP/PRG1_08042024_07.dmp”… Read more..

expdp from lower version (11.2.0) and import into higher version (19.x) in pluggable DB Check the status of database. SQL> select instance_name,version, open_mode from v$instance, v$database; INSTANCE_NAME           VERSION        OPEN_MODE —————- ——————————— testdb              … Read more..

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