Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-31089: schema "string" does not target namespace "string"

1 Answers  


PCC-00121: Arrays of VARCHAR pointers are not supported

1 Answers  


NID-00109: DBNAME string length number exceeds maximum length of number

1 Answers  


QSM-02148: many to many subquery joins require 9.0 compatibility or higher

1 Answers  


ORA-19667: cannot do incremental restore of datafile string

1 Answers  






ORA-06525: Length Mismatch for CHAR or RAW data

1 Answers  


ORA-31447: cannot create change tables in the SYS schema

1 Answers  


NNL-00919: Time until server shutdown: string

1 Answers  


NNO-00614: enabling FORWARDING-DESIRED on system queries

1 Answers  


ORA-00329: archived log begins at change string, need change string

1 Answers  


ORA-01254: cannot end online backup - file string in recovery manager backup

1 Answers  


PLS-00217: NUMBER scale constraint must be in range (-84 .. 127)

1 Answers  






Categories