Database Administration (MOSC)

MOSC Banner

exporting from SYSTEM tablespace - importing into user tablespace

edited Mar 11, 2010 7:53AM in Database Administration (MOSC) 3 commentsAnswered
 Sorry, if I come up again with this question. I tried to find a post of mine I did on the same topic in the old metalink fores but I can't find that post and didn't write the recipe down at that time.
Now I forgot the steps to do. Is it possible to access the old posts from the old metalink?

Anyway, here my question:

We have a 9i database that had the user tables created in the SYSTEM-Tablespace and I would like to "repair" this
circumstance by moving the tables of that USER (the only USER in that instance) into a different TABLESPACE.

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