Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Change default tablespace for a schema

568397Mar 22 2007 — edited Mar 23 2007

I have a user created initially with the default tablespace A.

My Questions:
I'd like to change his default tablespace A to a defauft tablespace B ?
What happens to his previous tables created in tablespace A after changing to tablespace B ?

Apart from exp/imp, what is the other way to do it ?

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 20 2007

Added on Mar 22 2007

#general-database-discussions

4 comments

3,869 views