Database Utilities (MOSC)

MOSC Banner

Database backup through expdp into different user

edited Jan 19, 2015 10:02AM in Database Utilities (MOSC) 4 commentsAnswered

Dear All,

Recently we start using expdp utility to taking our backups, and we notice that we can only import in the same database user, can someone explain how we can import data into different user.

I am using following command to get exported data:

expdp scott/tiger@abdb directory=dpdir dumpfile=abdb.dmp logfile=abdb.log


for say we want to import abdb.dmp from scott to comptest.


Regards,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center