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 |
SQL*Loader-00480: EXPRESSION may not be used with elements of a collection.
ORA-30376: prevent sharing of a parsed query of an explain rewrite session
ORA-02035: illegal bundled operation combination
ORA-25441: duplicate column value for table alias: string
ORA-07281: slsget: times error, unable to get cpu time.
IMP-00076: Missing NLS_NCHAR_CHARACTERSET in props$
ORA-01751: Invalid dump undo option
DRG-11425: gist level string is invalid
NZE-28771: Data source is not yet initialized.
NZE-29136: The allocated buffer is too small.
ORA-02843: Invalid value for kernel flag
ORA-24159: invalid variable definiton