HOW to increase DB_FILES?

From: DLEUNG <Dleung_at_cris.com>
Date: 1997/10/01
Message-ID: <60t0ia$dmq@examiner.concentric.net>#1/1

HI ,

   I am trying to increase the Max.number for DB_FILES in oracle 7.32. (solaris platform),
because I would like to add more files to a tablespace.

BUt I got the following error:
alter tablespace data05 add datafile '/u9/oradata/CNC01/data05_u9.dbf' size 150M *
ERROR at line 1:
ORA-00059: maximum number of DB_FILES exceeded

---

I go to init_instance_name.ora
and change the db_files from 20 to 40 ,
and then shutdown oracle and bring up by startup.
BUt it still say the same error.

I call Oracle support,
they told me instruction of recreate control_files to increase MAXDATFILES,
I can successfully increase the MAXDATAFILES to 60, but it does not help me ,
I try to add one additional (new ) file to a tablespace data05 , I havethe exact error again.

I really appreciate if anyone can give me some help/hint, because ORacle Support is very unhelpful. They told me , it should work.
I am wondering whether MAXDATAFILES has anything to do with DB_FILES?

Please email me directly, because I dont read this news group that often

Thank you in advance,

Dominica Leung

dleung_at_cncx.com

or dleung_at_concentric.net Received on Wed Oct 01 1997 - 00:00:00 CDT