RelationalDBDesign RelationalDBDesign


SQL*Loader   «Prev 

Move or Relocate a Table

ALTER TABLE tablename MOVE
[TABLESPACE tablespacename]
[PCTFREE n]
[PCTUSED n];

ALTER TABLE PRODUCT_OBJ_TABLE MOVE
TABLESPACE USER_NEXT;

ALTER TABLE CUSTOMER_OBJ_TABLE MOVE
PCTFREE 15;

Location 1 Choose one of these three options. Choosing the TABLESPACE option relocates the table to the specified tablespace. The other choices reorganize the table.
Location 2 This table is moved to a new location.
Location 3 This table is reorganized.