Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: moving tables from the system tablespace to a new tablespace
thanks for the help, it worked really well.
I used 'alter table xxxx move tablespace YYYY' since it is 8i and not under the SYS user.
C.
In article <398FE848.A5E83F1B_at_demon.co.uk>,
holders <holders_at_demon.co.uk> wrote:
> 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.
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Aug 09 2000 - 00:00:00 CDT