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-06752: TLI: error in signal setup
PLS-00234: PARAMETER STYLE SQL may not be specified with a PARAMATERS list
DRG-11624: invalid attribute string for string: proper range string to string
ORA-30037: Cannot perform parallel DML after a prior DML on the object
ORA-09718: osnsui: cannot set up user interrupt handler.
ORA-26034: Column string does not exist in stream
NNL-00306: Server setting all statistic counters to zero
RMAN-08035: partial resync skipped, target database not mounted
NZE-28775: file cannot close
ORA-36808: (XSTBLFUNC04) The OLAP_TABLE function LEVELREL clause cannot declare number ADT fields from number AW fields.
ORA-09218: sfrfs: failed to refresh file size
TNS-04231: Trace Assistant WARNING: Assuming Oracle trace format