Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SYSTEM Tablespace - condensing/compressing
Anthony Smith wrote:
>
> I would like to reduce our 3 data files for the SYSTEM tablespace
> into one.
You have to fully export your database, and then recreate the database
with
proper parameters and data files resized and relocated, and import the
whole database.
Hui, Kwok Miu (Xu, Guo Miao) E-Mail: huikomix_at_dt.com.hk Assistant MIS Manager Tel : (00852)2589 3369 Cho Yang (Hong Kong) Co., Ltd. Fax : (00852)2559 3049Received on Tue Jan 14 1997 - 00:00:00 CST