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: DB_FILES exceeded ORA-00059

Re: DB_FILES exceeded ORA-00059

From: Ken Shirey <kshirey_at_spindle.net>
Date: 1996/11/23
Message-ID: <32970181.1A71@spindle.net>#1/1

David E. Daniel wrote:
>
> I am trying to create a new tablespace of 500M. The disk is 4G and
> clean (new). I am getting an ORA-00059 error. The file is created but
> the database does not recognise it.
>

Check the init<sid>.ora file for the parameter

   DB_FILES= ... Oracle uses this parameter to limit the number of data files it will use. I commonly
set this parameter to 200 or more, so that if I need to add a datafile on the fly,
I don't have to "bounce" the database.

By the way, Delete the OS file before trying to recreate the datafile in Oracle.
Be careful not to delete any datafiles Oracle is using! You can find this info by:

  select file_name, status
  from sys.dba_data_files;

<snip>
Good luck,
Ken Shirey
Oracle Database Administrator
PrimeCo Personal Communications, LLP
kshirey_at_primeco.com Received on Sat Nov 23 1996 - 00:00:00 CST

Original text of this message

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