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: SYSTEM Tablespace - condensing/compressing

Re: SYSTEM Tablespace - condensing/compressing

From: Komix Hui <huikomix_at_dt.com.hk>
Date: 1997/01/14
Message-ID: <32DBBA01.5BC2@dt.com.hk>#1/1

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 3049
Received on Tue Jan 14 1997 - 00:00:00 CST

Original text of this message

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