How to export the data of Physical standby database (DataGuard) using the network link. Note: Consider your production database has primary and standby database, during the business hours it is not recommend to take the export of data from the primary database due to the performance issue might occur., Therefore we can perform the export Read More

How to export the dumpfile backup in Pluggable Database(PDB) using expdp in 19C Note: In Multitenant database., You will have the container database along with one or more PDB database. Check the database status SYS> select name, database_role, version from V$database, v$instance; NAME DATABASE_ROLE VERSION ————————————- ORA19CDB… Read more..

How to Manage the resource usage with concurrent job limit for each pluggable database using the Oracle Datapump in Oracle 19C Brief: The parameter “max_datapump_jobs_per_pdb” is controls the maximum number of concurrent session in Data Pump jobs for each pluggable database. Impact on this parameter: If you set this parameter to high value… Read more..

How to perform the export a percentage (%) of data from the schema tables in Oracle 19C Database Brief: Consider i have a requirement of the export of data in the form of percentage, Such as i need to export only 50% or 25% of data from my tables The parameter: SAMPLE can be used 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 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..