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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Any way to 'truncate' the control file?

RE: Any way to 'truncate' the control file?

From: Norris, Greg <Greg_Norris_at_mail.dor.state.mo.us>
Date: Wed, 2 Aug 2000 07:26:01 -0500
Message-Id: <10577.113579@fatcity.com>


Are you using rman for backups? It will store backupset information in the control file, if you don't opt to use a recovery catalog.

As far as shrinking the control file, the only option that I'm aware of is to recreate it.

> -----Original Message-----
> From: Zhong Hong [mailto:zhong_at_cantametrix.com]
> Sent: 01 August, 2000 6:56 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Any way to 'truncate' the control file?
>
>
> My contril file is about 39MB for a 150GB Database. Anybody
> knows what could
> cause that and how to reduce the size?
Received on Wed Aug 02 2000 - 07:26:01 CDT

Original text of this message

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