ORA-00059

Hello all

I have a oracle database v8174 running on a solaris 5.8 64bit, Iwas creating a tablespace then I got the following error message:

"ORA-00059: MAXIMUM NUMBER OF DB_FILES exceeded"

I have made a query to the database to v$controlfile_record_section and is showing that
my record size is 180, records used 200 and total records 215 on the datafile site. ALso I have viewed the database creation script and there is not maxfiles parameter, which to my knowledge means that oracle is taking the default 200? My question is if I change the init.ora to db_files = 1000, then restart oracle is there anything else at OS level that I should be looking into? I'm really worried about this, if I change the init.ora and if oracle does not came up.... or something else

I would really apreciate any help
Thanks
Teresa Received on Fri May 16 2003 - 20:25:27 CDT