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 |
PCC-01515: FIPS warning: Undeclared host variable "string" at line number in file string
ORA-12213: TNS:incomplete PREFERRED_CMANAGERS binding in TNSNAV.ORA
ORA-07425: sdpri: error string in translating dump file location.
ORA-28117: integrity constraint violated - parent record not found
ORA-01611: thread number string is invalid - must be between 1 and string
TNS-01407: Status: string Total handlers: string Relevant handlers: string
ORA-13129: HHCODE column string not found
TNS-03511: Used parameter files: string
NNL-00211: Cache checkpoint interval is now string
ORA-30083: syntax error was found in interval value expression
ORA-12814: only one CACHE or NOCACHE clause may be specified
ORA-14267: cannot specify PARALLEL clause when adding a (Composite) Range partition