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 Thu Apr 23 1998 - 10:22:55 CDT
