Re: DB_FILES exceeded ORA-00059

David E. Daniel (david.daniel_at_wmich.edu) 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.
 

: After scanning the "massive" amount of information regarding this error,
: I have come to the conclusion that I do not have enough memory on my
: machine. I currently have no other processes or users running.
 

: Am I correct in my assumptions?
: If so what am I to do from here?
: If not what else could be the problem?
 

: Any help would be greatly appreciated.
 

: Regards,
 

: David E. Daniel
: Western Michigan University

The number of datafiles in your database equals the number of files defined by the DB_FILES parameter in the database init file.

Increase the value specified.
Bounce your database.
Remove the file that was created.
Action create tablespace again.

NOTE if you are unable to increase the value DB_FILES specified is

     equal to MAXDATAFILE allowed for your database.  If this is the
     case you will first need to recreate your database control file/s
     to specify a larger MAX.

Hope this helps.	Helen