Re: Datafile sizes

Zhu,

Excellent points. As you point out, you must keep increasing db_files, and rebooting for that to take effect (I haven't checked 10g). But when you created the database, you set a MAXDATAFILES value. DB_FILES can't exceed MAXDATAFILES. If you still have the script used to create the database, you can find your MAXDATAFILES value. Otherwise you can alter database backup controlfile to trace, then find it in the trace file. To increase MAXDATAFILES, you must rebuild the control file, a somewhat nerve-wracking operation for a production database.

Dennis Williams

--
http://www.freelists.org/webpage/oracle-l