How Do You Move Tables From One Tablespace To Another Tablespace?

1.	How Do You Move Tables From One Tablespace To Another Tablespace?
Answer» There are several METHODS to do this; EXPORT the table, DROP the table, CREATE the table DEFINITION in the new tablespace, and then import the data (imp ignore=y). Create a new table in the new tablespace with the CREATE TABLE statement AS SELECT all from source table command. CREATE TABLE temp_name TABLESPACE new_tablespace AS SELECT * FROM source_table; Then drop the original table and rename the temporary table as the original: DROP TABLE real_table; RENAME temp_name TO real_table. There are several methods to do this; CREATE TABLE temp_name TABLESPACE new_tablespace AS SELECT * FROM source_table; Then drop the original table and rename the temporary table as the original:

Answer»

There are several METHODS to do this;

EXPORT the table, DROP the table, CREATE the table DEFINITION in the new tablespace, and then import the data (imp ignore=y).
Create a new table in the new tablespace with the CREATE TABLE statement AS SELECT all from source table command.

CREATE TABLE temp_name TABLESPACE new_tablespace AS SELECT * FROM source_table;

Then drop the original table and rename the temporary table as the original:

DROP TABLE real_table;
RENAME temp_name TO real_table.

There are several methods to do this;

CREATE TABLE temp_name TABLESPACE new_tablespace AS SELECT * FROM source_table;

Then drop the original table and rename the temporary table as the original:

Discussion