ORA-00059: maximum number of DB_FILES exceeded
Answers were Sorted based on User's Feedback
Answer / guest
Cause: The value of the DB_FILES initialization parameter
was exceeded.
Action: Increase the value of the DB_FILES parameter and
warm start.
Please add more information about this Error
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / prasant
When u are facing this type of error,as a DBA point of view
step-1:Show parameter db_files;
Step-2:U can increase the db_files size by executing
alter system set db_files=750 scope=spfile;
step-3:shutdown immediate;
step-4:start up;
As simple U can now crate tablespace.
byeee
| Is This Answer Correct ? | 3 Yes | 2 No |
ORA-01118: cannot add any more database files: limit of string exceeded
ORA-16007: invalid backup control file checkpoint
ORA-29343: user string (mapped from user string) does not exist in the database
NNL-00950: Cache lookup requests: number
ORA-32309: object mview type "string"."string" does not match the master table type
ORA-19634: filename required for this function
ORA-29876: failed in the execution of the ODCIINDEXDELETE routine
ORA-12562: TNS:bad global handle
ORA-08112: a composite partition may not be coalesced as a whole
ORA-22863: synonym for datatype string.string not allowed
ORA-15109: conflicting protection attributes specified
ORA-08266: create_ora_addr: cannot register name in nameserver