Database Utilities (MOSC)

MOSC Banner

alter table XXX.YYYY move question

edited May 18, 2011 7:34PM in Database Utilities (MOSC) 4 commentsAnswered
Hi,

I have to defrag several tables and I was given the following code in order to do it:

ALTER TABLE owner.tablename MOVE TABLESPACE tablespace_name NOLOGGING PARALLEL; 

the table will reside in the existing tablespace

everything I have read state to run the following:

ALTER TABLE owner.tablename MOVE;

I rebuild the indexes and run stats after doing this for both ways.  My question is: are these two statements equivalent?

Thanks, Pete

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