Clever Geek Handbook

Alter Table Move Command - ORACLE

Consider that I have TABLE 1 in tablespace TS1. I have a different TS2 tablespace.

What is the difference between the three below

  • TABLE TABLES TABLES1 USER MOVES ARE PARALLEL;

  • ALTER TABLE TABLE1 MOVE TABLESPACE TS1 NOLOGGING PARALLEL;

  • ALTER TABLE TABLE1 MOVE TABLESPACE TS2 NOLOGGING PARALLEL;

Thanks in advance.

+3


source to share


1 answer


As per the database SQL language reference :

move_table_clause

allows you to move data from a non-segmented table or partition of a partitioned table to a new shard, optionally to another tablespace, and possibly change any of its storage attributes.

So with your first statement Oracle will move the table to a new segment in the same tablespace, while in the other two operations Oracle will move the table to a new segment in the specified tablespace (TS1 and TS2 respectively).



If it is TABLE1

already in the tablespace TS1

, then the first and second commands will perform the same action.

Using MOVE

without changing the tablespace simply reorganizes the segment in the original tablespace.

+5


source






More articles:


All Articles