Database Administration (MOSC)

MOSC Banner

NowI have dump of multiple schemas taken using traditional export method. Need to import into a ne

edited Oct 13, 2014 4:41AM in Database Administration (MOSC) 5 commentsAnswered

The Data and Index tablespaces on the source are maintained separately. So i need to maintain the same on the new System How do i achieve it?

My understanding if it were to have tablespaces where data and indx were not maintained separately then.... i would go for this approach.

create new user in target db with a new tablespace name Make that tablespace  its default tablespace. Grant unlimited quota on that tablespace to thenew user.

export file =<> log =<> fromuser=  xyz touser=<xyz>  ...rest of the optional parameters. This will take care of the tablespace remapping.


But in my case i have maintain Data and Index tablespaces separately. How do i achieve it... Kindly help !!!

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