Posted by Mir Sayeed Hassan on 24th November 2024
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
Posted in Datapump (Expdp/Impdp) | Comments Off on How to export the dumpfile by using the LOGTIME parameter using expdp in Oracle database 19C
Posted by Mir Sayeed Hassan on 20th November 2024
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..
Posted in ORA-Error | Comments Off on Error opening the PDB db as MAX_STRING_SIZE migration is incomplete for pluggable database PDB$SEED in Oracle 19C DB
Posted by Mir Sayeed Hassan on 13th November 2024
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..
Posted in Datapump (Expdp/Impdp) | Comments Off on How to export the dumpfile backup into multiple directory in Oracle database 19C
Posted by Mir Sayeed Hassan on 13th November 2024
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..
Posted in Datapump (Expdp/Impdp) | Comments Off on How to create a logical directory in Oracle Database 19C for Export & Import (expdp/impdp)
Posted by Mir Sayeed Hassan on 13th November 2024
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..
Posted in Datapump (Expdp/Impdp) | Comments Off on How to export the dumpfile default directory location in Oracle database 19C