Re: ORA-01118 error

You can create new controlfiles.

alter database backup control file to trace;

edit de trace file that appears.

use this to recreate the controlfiles.

Sylvain Leclerc <SLeclerc_at_magrit.com> wrote in article <044CD796C702D111B56800608CCC51D004002A_at_INT_04>...
> Inceasing the db_files wont do, it also depends on your MAXDATAFILES at
> creation time. The size of the control file is based on this. Thats
> why you need to recreate the database.
>
> > -----Original Message-----
> > From: Pete Etten [SMTP:ettenp_at_reston.btna.com]
> > Posted At: Wednesday, April 22, 1998 10:14 AM
> > Posted To: server
> > Conversation: ORA-01118 error
> > Subject: Re: ORA-01118 error
> >
> > Try increasing the db_files parameter in the init<SID>.ora.
> >
> > Italo Bozzi Feuereisen wrote in message
> > <6hkrbm$nu8$1_at_aconcagua.ctcreuna.cl>...
> > >Dear friends:
> > >
> > >We have the next problem. Yesterday I tried to create a new
> > tablespace,
> > the
> > >command was terminated with the next Oracle error:
> > >
> > > ORA-01118 cannot add any more datafiles: limit of 30 exceeded
> > >
> > >The Oracle Manuals recommend to recreate the database. Exist any
> > >possibility to not recreate the database?
> > >
> > >We have Oracle 7.3
> > >
> > >Thanks,
> > >
> > >
> > >Italo.
> > >
> > >
> > >
> >
>
>
Received on Tue Apr 28 1998 - 04:33:41 CDT