Re: moving tables from the system tablespace to a new tablespace

Hi,

1. Use 'alter table xxxx move tablespace YYYY (only for 8i)
2. Create table XXXX tablespace new unrecoverable as select * from FFFF
3. First create the table then insert into it i.e. insert into XXXX select * from YYYY
4. Export/ drop old table /create table in new tablespace /import

Above are just some of the ways. Be carefull of logging (use unrecoverable/nologging, APPEND hint)

SH

cferring_at_my-deja.com wrote:

> Hi everyone,
>
> due to poor design, some of our Production tables are in the System
> tablespace.
>
> I want to create a new tablespace or two, and move those Production
> tables off the System tablespace.
> What are my options?
>
> I think about Exporting the System tablespace, create one or two new
> tablespace, import the System one into one of those.
> Would that work well (since it's the System Tablespace)?
>
> Otherwise, should I rebuild the whole database (please don't say so)?
> Any good advise?
>
> thanks in advance,
> C.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Aug 08 2000 - 00:00:00 CDT