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 ....
EXPDP
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. expdp dumpfile=full1.dmp logfile=full1.log directory=T filesize=100m full=y Starting "SYS"."SYS_EXPORT_FULL_01": /******** AS SYS...
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...
ORA-39358: Export dump file version not compatible
PROBLEM: While importing dump file, got error as ORA-39358: Export dump file version 12.1.0.2.0 not compatible with target version 11.2.0.4.0 . SOLUTION: 1. Check the compatible parameter of both sour...
expdp backup using shell script
Requirement: Configure a shell script, to take export backup of table daily at 3 PM and send the log to stake holders. Script: ( EXP_TAB_cmprss.sh) # $Header: EXP_TAB_cmprss.sh # *==================...
Datapump New features in Oracle 12.2
A lot of enhancements has been done in Oracle 12.2 Release. In this article We will explain the new features of datapump utility in oracle 12.2 Release. 1.Parfile content written t...