Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DB_FILES exceeded ORA-00059
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