############### 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.
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