How to export the dumpfile backup into multiple directory in Oracle database 19C Check the database version SYS> select name, status, open_mode, version from V$database, v$instance; NAME STATUS OPEN_MODE VERSION ———————————————— ORA19CDB OPEN READ WRITE 19.0.0.0.0 This scenario… Read more..

How to create a logical directory in Oracle Database 19C for Export & Import (expdp/impdp) Check the database version SYS> select name, status, open_mode, version from V$database, v$instance; NAME STATUS OPEN_MODE VERSION —————————————————- ORA19CDB OPEN READ WRITE 19.0.0.0.0 Login… Read more..

How to export the dumpfile default directory location in Oracle database 19C Check the database version SYS> select name, status, open_mode, version from V$database, v$instance; NAME STATUS OPEN_MODE VERSION ————————————————- ORA19CDB OPEN READ WRITE 19.0.0.0.0 The name of… Read more..

Export the data by using the where clause from Pluggable database in Oracle 19C Check the database status SQL> select instance_name,version, open_mode from V$instance, v$database; INSTANCE_NAME VERSION OPEN_MODE —————- ————————– prod1db 19.0.0.0.0 READ WRITE Check the CDB & PDB… Read more..

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