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 |
PLS-00634: type with NOT INSTANTIABLE methods must be declared NOT INSTANTIABLE
EXP-00080: Data in table "string" is protected. Using conventional mode.
QSM-00796: the specified SQL statement cannot be stored in the workload because table string does not have valid statistics
ORA-12468: max write level does not equal max read level
ORA-12435: invalid audit success: string
RMAN-06748: no or more than one tertiary storage channel found
RMAN-06506: the MAXSETSIZE option cannot be used with a backup backupset
ORA-29915: cannot select FOR UPDATE from collection operand
ORA-14268: subpartition 'string' of the partition resides in offlined tablespace
ORA-28510: heterogeneous database link initialization failed
PCB-00631: Host variable is not an External LOB
ORA-23338: priority or value already in priority group string