EXPDP

ENCRYPTION in expdp impdp

We can enable password based encryption for expdp dumps, by using different encryption related parameters in expdp/impdp command. ENCRYPTION RELATED PARAMETERS: ENCRYPTION Encrypt part or all of a dum...

Cluster parameter in oracle RAC database

In a RAC database, if you are taking export with the parallel option and the datapump directory is not shared between the nodes, then export might fail with below error Because the remote node is unab...

Datapump export to ASM diskgroup (EXPDP)

It is tvery common to export dump file to the standard file system(Mount points). However, we can export the dump files to ASM diskgroup also. In this article, we will show the steps for this . DEMO 1...

How to do import using network_link in oracle

By using network_link parameter, we can directly import the data from source database to target database without generating the dump file. This will need a database link between source and target db ....

How to run expdp in pluggable database(PDB)

In the multitenant database, For getting an export dump from the pluggable database, we need a follow a bit different process. DEMO: PLUGGABLE DATABASE(PDB) – PRE1 SCHEMA_NAME – DBACLASS (...

How to use expdp to export data from physical standby database

During peak business hours, It is not advised to export data from production .(as it might impact the performance). So if we have a physical standby database, we can export data using datapump from st...

ORA-39095: Dump file space has been exhausted: Unable to allocate

PROBLEM: While running expdp with filesize parameter, got below error. [crayon-5beda11ce3d94902035829/] SOLUTION: FILESIZE parameter limits the size of the dumpfile to the mentioned size. if the dumps...

Schedule expdp job in dbms_scheduler

We usually schedule expdp jobs in a standard shell script.  But the same can be achieved using dbms_scheduler utility also. Below are steps for scheduling expdp job. Here we will schedule a full expd...

ORA-39174: Encryption password must be supplied

PROBLEM: While importing a dump, getting below error: Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production With the Partitioning, OLAP, Advanced Analytics a...

ORA-31617: unable to open dump file for write

PROBLEM: While taking expdp in rac database, got below error. ORA-31617: unable to open dump file “/dumparea/TEST/asset_75.dmp” for write ORA-19505: failed to identify file “/dumparea/TEST/asset...

Page 1 of 212
Skip to toolbar