Database Utilities (MOSC)

MOSC Banner

Recreating full schema tablespace/datafiles

edited Jun 13, 2013 4:26AM in Database Utilities (MOSC) 3 commentsAnswered
I have a particular schema that I would like to drop both index and data tablespaces and recreate all their datafiles.  I plan to use datapump to do a schema export/import.  I have verified that all segments (via dba_segments) in these tablespaces are owned by a single schema account and this account does not own any segments outside of these tablespaces. I am concerned that completely dropping the tablespaces and contents, then reimporting the datapump file may not recreate all necessary database entities (ie public grants, sequences, packages, etc).

Can you please verify if these are the proper steps and whether or not anything is missing:

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