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

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