Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> file limit
Consider upgrading Oracle7.3. You can set data-files to auto-extend up to 2Gb (depending on your backup solution). In the meantime, you'll need to carefully size your datafiles so that you avoid this problem. You can also do a "alter database backup control file to trace;". Then take the trace log generated by this command, modify the maxdatafiles parm,and use it to re-create a new group of control files. Make absolutely, positively sure that you back everything up cold first. Received on Fri Aug 15 1997 - 00:00:00 CDT