From: holders <holders@demon.co.uk>
Subject: Re: moving tables from the system tablespace to a new tablespace
Date: 2000/08/08
Message-ID: <398FE848.A5E83F1B@demon.co.uk>#1/1
Content-Transfer-Encoding: 7bit
X-NNTP-Posting-Host: holders.demon.co.uk:158.152.189.12
References: <8moa6l$dof$1@nnrp1.deja.com>
X-Accept-Language: en
Content-Type: text/plain; charset=us-ascii
X-Complaints-To: abuse@demon.net
X-Trace: news.demon.co.uk 965732758 nnrp-13:20192 NO-IDENT holders.demon.co.uk:158.152.189.12
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server


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@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.