Mir Sayeed Hassan – Oracle Blog

Apply the latest OPatch 6880880 (12.2.0.1.45) issued on Jan-2025 on 19C Database

SQL> select instance_name, version, open_mode from v$database, v$instance;

INSTANCE_NAME VERSION OPEN_MODE
---------------- ----------------- --------------------
ora19ctdb1 19.0.0.0.0 READ WRITE

Check existing OPatch applied.

[oracle@ora19ctdb ~]$ $ORACLE_HOME/OPatch/opatch... 
Read more..			

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 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 use this parameter...
Read more..