Re: Q) Changing Max # of Datafiles... (But it does not work...)

From: Ian Cary <cary_at_gatwick.geco-prakla.slb.com>
Date: 1997/12/05
Message-ID: <34881058.2FA51C2D@gatwick.geco-prakla.slb.com>#1/1

ksjune_at_sys.gsnu.ac.kr wrote:

> =========================================================================
> STARTUP NOMOUNT
> CREATE CONTROLFILE REUSE DATABASE "ORACLE" NORESETLOGS ARCHIVELOG
> ...........
>
>
> ORA-01503: CREATE CONTROLFILE failed
> ORA-00213: cannot reuse control file 'D:\ORANT\DATABASE\ctl1orcl.ora';
> old file size 310, 358 required

The error message you are getting is because your new control file is physically larger than your old one yet you are trying to reuse the old file. You will need to delete the original control file; D:\ORANT\DATABASE\ctl1orcl.ora
before executing this command (which will create a replacement)

Regards,

Ian Received on Fri Dec 05 1997 - 00:00:00 CST