Re: ora-1118 (create tablespace)

I have had a similar problem. What has happened is that you created the database with the maxdatafiles either at 30 or the default. If you use the oracle installer to create the database it issues the create database statement using the default value for maxdatafiles. To correct this you can:
 -issue the command to create a sample control file

           alter database backup controlfile to trace;  -modify the trace created by the above step - add the maxdatafiles parameter

-shutdown the database normal
-startup nomount
-issue the create controlfile command
-startup the database (alter database open).

Be very careful doing this!!!!! Make a backup of the current controlfile with the DB shut down. If possible, do a full cold backup before trying this.

jolsen_at_mindspring.com
www.mindspring.com/~jolsen/home.html

Mohan Vijay <ou90764_at_deere.com> wrote:

>Hi !

>Iam getting this error (ora-1118) while trying to create a tablespace.
>The db_files limit which was 30 was made 40, and the database was
>restarted.The interesting thing is the datafile gets physically created
>in the specified directory but cannot be seen thru dba_tablespaces or
>dba_data_files.This is on an AIX running 7.1.4.
 

>Any ideas ?
 

>Thanks in advance
 

>Mohan
>ou90764_at_deere.com
Received on Fri May 03 1996 - 00:00:00 CEST