OraFAQ Forum: Server Administration » ORA-00059 db files exceeded

Home » RDBMS Server » Server Administration » ORA-00059 db files exceeded

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-00059 db files exceeded [message #57037]

Thu, 15 May 2003 19:49

Teresa
Messages: 36
Registered: May 2002

Member

Hi all

I was creating a new tablespace and I got this error message
"ORA-00059: MAXIMUM NUMBER OF DB_FILES exceeded"

can any one please tell if this is the correct syntax to change the init.ora

db_files = 500

Thanks Teresa

Report message to a moderator

Re: ORA-00059 db files exceeded [message #57040 is a reply to message #57037]

Fri, 16 May 2003 01:29

Naveen
Messages: 75
Registered: June 2001

Member

Hi,

The syntyax is correct. But check the maxdatafiles specified in the controlfile. I think the number of datafiles in the database should not excced the number specified in maxdatafiles. To check use v$controlfile_record_section. Concentrate on the records_total column for type=datafile .
hope this helps.

Regards---Naveen

Report message to a moderator

Re: ORA-00059 db files exceeded [message #57047 is a reply to message #57040]

Fri, 16 May 2003 09:41

Teresa
Messages: 36
Registered: May 2002

Member

thanks for your help it really help me
when I did the query I got this

TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX LAST_RECID
----------------- ----------- ------------- ------------ ----------- ---------- ----------
DATABASE 192 1 1 0 0 0
CKPT PROGRESS 4084 1 0 0 0 0
REDO THREAD 104 1 1 0 0 0
REDO LOG 72 16 10 0 0 30
DATAFILE 180 215 200 0 0 2647
FILENAME 524 218 210 0 0 0
TABLESPACE 68 42 41 0 0 161
RESERVED1 56 30 0 0 0 0
RESERVED2 1 1 0 0 0 0
LOG HISTORY 36 1361 1361 140 139 15562
OFFLINE RANGE 56 145 0 0 0 0

TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX LAST_RECID
----------------- ----------- ------------- ------------ ----------- ---------- ----------
ARCHIVED LOG 584 111 0 0 0 0
BACKUP SET 40 204 0 0 0 0
BACKUP PIECE 736 66 0 0 0 0
BACKUP DATAFILE 116 70 0 0 0 0
BACKUP REDOLOG 76 107 0 0 0 0
DATAFILE COPY 660 61 0 0 0 0
BACKUP CORRUPTION 44 185 0 0 0 0
COPY CORRUPTION 40 204 0 0 0 0
DELETED OBJECT 20 408 0 0 0 0
PROXY COPY 852 95 0 0 0 0
RESERVED4 1 8168 0 0 0 0

Report message to a moderator

Previous Topic:	About .Net compact framework and windows ce
Next Topic:	PRODUCTION DB - Some doubts -Pls help me out - Juli

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 30 16:44:15 CST 2024