Mir Sayeed Hassan – Oracle Blog

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

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