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-04080: trigger 'string' does not exist

1 Answers  


ORA-28236: invalid Triple DES mode

1 Answers  


RMAN-08121: keep attributes for the backup are deleted

1 Answers  


TNS-00025: INTCTL: The ORACLE environment is not set up correctly

1 Answers  


RMAN-06099: error occurred in source file: string, line: number

1 Answers  






TNS-12504: TNS:listener was not given the SID in CONNECT_DATA

1 Answers  


TNS-00304: Status Information for Connection Manager:

1 Answers  


ORA-26701: STREAMS process string does not exist

1 Answers  


PLS-00406: length of SELECT list in subquery must match number of assignment targets

1 Answers  


ORA-28156: Proxy user 'string' not authorized to set role 'string' for client 'string'

1 Answers  


PCC-00123: Entire VARCHAR declaration must be on same line

1 Answers  


PCC-01019: Invalid conversion buffer size

1 Answers  


Categories