alter table XXX.YYYY move question
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