Database Utilities (MOSC)

MOSC Banner

Copy all objects from one user to another

edited Jan 20, 2010 4:16AM in Database Utilities (MOSC) 10 commentsAnswered
 I need to copy all the tables, contents, indexes, and sequences from one user ownership to another user. What are the ways I can achieve this?

I understand that if I do 'create table as select...' will let me create the table structure and possibly the data as well.

I know that I can use export and import to copy table, data, and indexes, but what about sequence? Will export/import also carry over sequences? Any guru out there?

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