How to export the dumpfile by using the LOGTIME parameter using expdp in Oracle database 19C Brief: – This parameter LOGTIME give us the timestamp for each and every export operation during expdp., therefore its easy to check the diagnise/elapsed time taken for execution. – By default LOGTIME=NONE, If you want to use this feature Read More

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