Re: ora-1118 (create tablespace)
From: Dennis R. Otero <t10402_at_edamsksc.nasa.gov>
Date: 1996/05/03
Message-ID: <4mdktc$108_at_niven.ksc.nasa.gov>#1/1
Date: 1996/05/03
Message-ID: <4mdktc$108_at_niven.ksc.nasa.gov>#1/1
In article <318A3E5A.41C6_at_deere.com>, Mohan Vijay <ou90764_at_deere.com> writes:
> 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
In Appendix D of Server Administrator's Guide it states that the maxdatafiles can only be set at create database time and is for the life of the instance. Sorry.
Dennis _at_ KSC Received on Fri May 03 1996 - 00:00:00 CEST