Re: Move table to another tablespace

Hi Jan,
If this is the only table that needs to be reorganized, yes it is. Otherwise export the user, change his default tablespace and make sure he doesn't have quota on the original tablespace. Now import the data and tables will automatically end up in the new tablespace.

Hth,

Sybrand Bakker, Oracle DBA

Jan Dolman wrote:

> How can I move a table form one tablespace to another?
>
> I cannot find any SQL command that does so. The only method I can
> think of is to copy the table to a new one (using CREATE TABLE COPY
> AS SELECT * FROM ORIGINAL), dropping the original table, and then
> creating the original table again in the correct tablespace by using
> CREATE TABLE ORIGINAL. AS SELECT * FROM COPY again.
> Surely this cannot be the only way??
>
> Please help.
> Jan
Received on Mon Nov 09 1998 - 16:26:24 CST