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-27457: argument string of job "string.string" has no value
IMP-00041: Warning: object created with compilation warnings
ORA-24141: rule set string.string does not exist
ORA-32400: cannot use object id columns from materialized view log on "string"."string"
ORA-31083: error while creating SQL type "string"."string"
ORA-16515: no rcv channel
ORA-28672: UPDATE BLOCK REFERENCES may not be used on a global index
SQL*Loader-00106: Invalid discard file name on command line
ORA-01652: unable to extend temp segment by string in tablespace string
ORA-33454: (ESDREAD07) Discarding compiled code for workspace object because number is now string workspace object, whereas it was string workspace object when the code was compiled.
NZE-28827: invalid cipher type passed
AMD-00158: The Workspace "string" is currently open in read-only mode.