Movement of Objects from SYSTEM tablespace to USERS tablespace
Hello,
I'm using Oracle 11.2.0.3 database and I have below doubt.
Can I move schema from one tablespace (SYSTEM) to another tablespace (USERS) within same database while the application is up and running.
Will there be any impact if I move the objects (tables & indexes) while the application is running.
Cmds used:
-------------
alter table <table Name> move tablespace <new tablespace>;
alter index <Index Name> rebuild tablespace <New Tablespace>;
Thanks much,
0