Move user objects from SYSTEM tablespace to USERS tablespace
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