Re: Tablespace Question

From: spencer <spencerp_at_swbell.net>
Date: Sun, 29 Oct 2000 19:50:46 -0600
Message-ID: <Is4L5.127$%X3.113045@nnrp1.sbc.net>

in Oracle 8.0.6 and earlier, no, there is no statement that will change the tablespace for an existing table. but you can effectively "move" a table to a different tablespace:

create a new table in the desired tablespace, insert the rows from the original table into the new table, grant the required privileges on the new table, create any triggers, rename the original table to a different name, rename the new table to the original name, and then recompile any views, functions, procedures, and package bodies that reference the table.

HTH "Kian Lee" <ooiklnews_at_yahoo.com> wrote in message news:8tigt7$dca$1_at_nnrp1.deja.com...
> Is there a way to change a table's tablespace??
>
> Regards,
> Kian Lee
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Received on Sun Oct 29 2000 - 19:50:46 CST