Database Utilities (MOSC)

MOSC Banner

exp & imp schema-one database to another database.

edited Oct 26, 2015 8:59AM in Database Utilities (MOSC) 2 commentsAnswered

Dear experts,

I am using exp command for exporting the specific  schema in orcl database, the command that I am using are below :-

exp userid=SHLULSPROD/SHLULSPROD@kastle file=/backup/SHL/SHLULSPROD.dmp log=/backup/SHL/SHLULSPROD.log rows=y grants=y constraints=y statistics=none direct=n full=n consistent=y

Now I am planning to import SHLULSPROD schema to different database which is my test database, SHLULSPROD schema are exist in test database. so what command we can used for complete import the SHLULSPROD schema from orcl to test database with complete objects also imported.

Need your support.

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