Sunday, June 2, 2013

Moving Table Between Tablespace.

############### Creating Table Using Table Space #########

CREATE TABLE TEST_DATA_MOVE(ID NUMBER, NAME VARCHAR2(30)) TABLESPACE MICR;

############# Moving Tablespace  ###################

ALTER TABLE TEST_DATA_MOVE MOVE TABLESPACE MICRACK;

This is ensure your data also move with tablespace.

No comments:

Post a Comment