Hi Charlie... the parameter DB_FILES is set in the init file... you have to
bounce the instance after you increase it.
The parameter you are thinking of is MAXDATAFILES which is in the control
file. And you are correct; you would need to ALTER DATABASE BACKUP
CONTROLFILE TO TRACE, edit that MAXDATAFILES parameter, and recreate the
controlfile if it were exceeded. Sounds like you just need to change
DB_FILES though considering your error. DB_FILES and MAXDATAFILES can be
different; might generate the trace file anyway just to check that the
MAXDATAFILES setting is ok. I don't know of any other way to check it;
somebody else may have a better method.
BTW... is San Diego still as sunny as ever? I'm still hooking and jabbing
here in DC... send me some more pictures of the Pacific.
:-)
John Dailey, MCSE/MCP+I
Consultant
Concept Solutions, LLC
*Your Business Intelligence Partner*
www.concept-solutions.com
-----Original Message-----
Mengler
Sent: Tuesday, February 27, 2001 10:50 PM
To: Multiple recipients of list ORACLE-L
I just got the following ->
SYS: DBW.WORLD>ALTER TABLESPACE DAILY_SALES_TBL
2 ADD DATAFILE '/db19/oracle/DBW/daily_sales_tbl.dbf' SIZE
1802272768
3 /
ALTER TABLESPACE DAILY_SALES_TBL
*
ERROR at line 1:
ORA-00059: maximum number of DB_FILES exceeded
I fixed a similar problem about 4-5 years ago & I have a vague
recollection of what to do.
I need to do ->
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
I then find the trace file & edit it.
Besides increasing the line where the number of datafiles is specified;
what else do I need to do?
The exactly how do I use this file to start the instance?
If anyone can point me at some softcopy or hardcopy
documentation on this whole process, I'd appreciate it.
TIA!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Charlie Mengler
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Dailey
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
