Skip to Main Content

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!

Move user objects from SYSTEM tablespace to USERS tablespace

InayatqaziJun 16 2006 — edited Jun 21 2006
Hi friends Hoping u all fine
I have a huge database containing many users and a large no. of tables and their associated indexes and views. All this data is present in SYSTEM Tablespase. While it should be in a separete tablespace like USERS.
I want to move user objects(tables, Indexex, Vies..etc) from SYSTEM Tablespase to USERS Tablespase. I know one way of doing this is:

Alter table <tablename> move tablespace <newtablespacename>;

But as I mentioned i have large no. of objects, so this method is impossible for me.
Plz any body will tell me some other easy and appilcabe way to tackle this problem.

Thanks in advance

Inayat Qazi, DBA
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 19 2006
Added on Jun 16 2006
18 comments
1,464 views