How to use the REUSE_DUMPFILES Parameter using expdp in Oracle database 19C Brief: – In case if you use existing dumpfile name, you will get an error as its already exists, To overcome this use this REUSE_DUMPFILES=YES parameter to overwrite the existing dumpfile name without error. – By default is REUSE_DUMPFILES=NO Check the database… Read 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 the… Read more..

How to use the METRICS Parameter by using expdp in Oracle database 19C Brief: – This will give the information about the number of objects associated along with the elapsed time. – Default METRICS=N, To apply this Parameter use METRICS=Y Check the database version SYS> select name, status, open_mode, version from V$database,… Read more..

How to exclude the statistics, table_statistics, index_statistics when export of dumpfile 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… Read more..

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