Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Help for message ORA-01118.

Re: Help for message ORA-01118.

From: Brian W. Perez <bwp_at_shadow.net>
Date: 1997/10/05
Message-ID: <3437907a.28278121@news.shadow.net>#1/1

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:

  1. You have your DB_FILES init parameter set to low. If this is the case all you have to do is set it higher in your init file and bounce your instance.
  2. You created your database specifying maxdatafiles to low. If you did this you will have to recreate your controlfile.

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US