Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Reorganize tablespace system

Re: Reorganize tablespace system

From: Steve Phelan <stevep_at_XXnospamXX.toneline.demon.co.uk>
Date: 1998/03/23
Message-ID: <890642458.12413.0.nnrp-03.c2de712e@news.demon.co.uk>#1/1

You can't. You'll have to imp/exp. And recreate the SYSTEM tablespace with one datafile in between.

Steve Phelan.

Olivier Bercovitz wrote in message <35157A6D.6E3D60C3_at_club-internet.fr>...
>Hello everybody,
>
>My tablespace system is splitted to 3 datafiles and I would like to
>reorganize it
>into one datafile only.
>How can I do it without recreate the database ??
>
>Thanks for your help
>
>Regards. Olivier
>
Received on Mon Mar 23 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US