ORA-00059: maximum number of DB_FILES exceeded

Answers were Sorted based on User's Feedback



ORA-00059: maximum number of DB_FILES exceeded..

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

ORA-00059: maximum number of DB_FILES exceeded..

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

Post New Answer

More Oracle Errors Interview Questions

ORA-06702: TLI Driver: cannot allocate context area

1 Answers  


ORA-36735: A value exceeded the MAX specification

1 Answers  


ORA-00369: Current log of thread string not useable and other log being cleared

1 Answers  


KUP-03012: OCI error getting database column precision.

1 Answers  


ORA-22910: cannot specify schema name for nested tables

1 Answers  






NZE-28831: no data unit format

1 Answers  


NZE-29120: Cannot export certificate.

1 Answers  


ORA-13008: the specified date format has an invalid component

1 Answers  


ORA-37011: (XSACQUIRE_LOCKED) Object workspace object is locked by another user.

1 Answers  


PLS-00515: The type of the REF INTO variable 'string' must be REF to the table's type

1 Answers  


TNS-01408: Instance "string", status string, has string handler(s) for this service...

1 Answers  


SQL*Loader-00436: error converting GUID

1 Answers  


Categories