Database Utilities (MOSC)

MOSC Banner

EXP/IMP Making the cloned username into separate username and how to consolidate the state of DB obj

edited Oct 18, 2013 2:32AM in Database Utilities (MOSC) 7 commentsAnswered
Hello,

Any experience, help and direction is most apreciated.

On the database have one username which is spreaded on two tablespaces:

source_User: ts1_data, ts2_indx.

Should provide the functionality in regular procedure that this User is in some period of time 
cloned to dest_User: ts2_data, ts2_indx.

the objects of both users should be in valid state after cloning.
So there is possibility of confrontation because of for example two different table_names with samen names, public synonyms that are formed on the objects in source_User1,
triggers that are formed on tables in source_User1.

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