Mir Sayeed Hassan – Oracle Blog

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

Error opening the PDB db as MAX_STRING_SIZE migration is incomplete for pluggable database PDB$SEED in Oracle 19C DB

Check the database version

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

NAME       OPEN_MODE       VERSION
--------------------------------------
PEPTEST    READ WRITE     19.0.0.0.0

Check the CDB & PDBS

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