Re: How do you change a tables tablespace?

Here are 3 possibilities:

1. Alter table move tablespace NEW; (requires Oracle 8 and no long columns)
2. create table temp as select * from TABLE; rename table TABLE as oldtemp; rename table temp as TABLE; rebuild indexes (requires no long columns).
3. export the table (exp utility) drop the original table rebuild the table (empty) in the new tablespace import the table (imp uqility).

I've listed the answers from easiest to most difficult. Let us know if you need further details on
option 3.

Robert Sherunkle wrote:

> Hi,
>
> I have some tables which have been created in the SYSTEM tablespace.
> How can I move them without losing the data.
>
> Thanks In Anticipation
>
> Sent via Deja.com
> http://www.deja.com/
  Received on Tue Jan 16 2001 - 02:23:20 CST