Re: Help for message ORA-01118.

Sir, I am super positive his MAXDATAFILE exceeded the limit..... You will have to recreate your control file with higher MAXDATAFILE value. do the following:

1. type from sqldba  " alter database backup controlfile to trace"
2. collect trace file from USER_DUMP_DEST destination
3. edit the file, change the value for MAXDATAFILE
4. RECREATE new controlfile...

now you are ready to go....
Make sure you have system privilege to open so many files.......consult your UNIX admin...

Luck.....

Stephen Cheung wrote:

> : When I attempt to create a tablespace, I receive message:
> : ORA-01118 CANNOT ADD ANY MORE DATABASE FILES
>
> It's possible that your DB_FILES value in your init<sid>.ora is just set too
> low. Shutdown the database, increase this value, restart and see if that
> solves your problem.
> -- Stephen
> --
> Stephen Cheung
> 512-916-8324 anytime.
> stephen_at_cyberservices.com

--
-------------------------------------------------------------------
Abu M Rahman                     | PHONE: (904) 737-3181 ext. 237
Database Administrator           | FAX  : (904) 739-1984
NKO, Inc.                        | Email: arahman_at_nko.com
-------------------------------------------------------------------