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-22632: AnyDataSet parameter is not valid for the current operation
ORA-23379: connection qualifier "string" is too long
ORA-29502: NAMED keyword required in CREATE JAVA RESOURCE
ORA-30386: invalid SQL statement for DECLARE_REWRITE_EQUIVALENCE
RMAN-06436: enter DROP CATALOG command again to confirm catalog removal
ORA-14112: RECOVERABLE/UNRECOVERABLE may not be specified for a partition or subpartition
DRG-50852: failed to turn SQL trace on
ORA-02332: cannot create index on attributes of this column
PCC-02339: host variables cannot be of union types
NNL-00307: Server checkpointing its cache
NCR-02009: NCRF: Unable to open trace file
ORA-01325: archive log mode must be enabled to build into the logstream