Re: Tablespace Question
Date: Sun, 29 Oct 2000 19:50:46 -0600
Message-ID: <Is4L5.127$%X3.113045_at_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
> 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 Mon Oct 30 2000 - 02:50:46 CET