Database Administration (MOSC)

MOSC Banner

Movement of Objects from SYSTEM tablespace to USERS tablespace

edited May 16, 2013 8:23PM in Database Administration (MOSC) 5 commentsAnswered
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,

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