Posts Tagged ‘ datapump restore ’

Oracle Datapump Various Scenario/Examples

I collected this content from this link.

Let’s experiment expdp & impdp utility for different scenarios. We have two database orcl, ordb. All the below scenarios are tested in Oracle10g R2 version.

Scenario 1 :

Export the whole orcl database.

Export Parfile content:

userid=system/password@orcl
dumpfile=expfulldp.dmp
logfile=expfulldp.log
full=y
directory=dumplocation Continue reading

Advertisements

oracle datapump backup restore in Linux

You can easily take data pump backup of an Oracle Schema in Linux environment following those easy steps. I have taken backup of SCOTT Schema and restore it again from this Backup.

However, SCOTT Schema is locked in Default Installation. You can unlock it using following sql command.


ALTER USER SCOTT ACCOUNT UNLOCK;

Continue reading

Advertisements