Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help for message ORA-01118.
On 4 Oct 1997 14:43:45 GMT, "Marco Vallecoccia" <e.vallecoccia_at_eurolink.it> wrote:
>When I attempt to create a tablespace, I receive message:
> ORA-01118 CANNOT ADD ANY MORE DATABASE FILES
>
>Message and Code manual tells me that I have to export the database e
>re-create it. Is there another solution ????.
This will be caused by one of two things:
ALTER DATABASE BACKUP CONTROLFILE TO TRACE; Now you will need to find your trace file and edit it. First remove all lines up to the CREATE CONTROLFILE statment. Also, change the maxdatafile entry in the sql statment.
It is a good idea to copy your controlfile before running the statment just in case. Also watch out if you are on Solaris because there is a nasty bug which can mess up your database completly in version 7.1.6.
Brian Received on Sun Oct 05 1997 - 00:00:00 CDT