Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Any way to 'truncate' the control file?
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