Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Reorganize tablespace system
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