Re: Does Oracle limit file

Bill Manry wrote:
>
> yyy_at_sun7mis.cc.nccu.edu.tw (Sunny Yeh) wrote:
> >Does oracle limit the database file ?
> >Can I create more than 1000 database file at the same time ?
>
> 1) Yes, there is a limit on the number of files comprising a database.
> 2) The limit varies by platform/OS and should be mentioned in your
> OS-specific documentation. On IBM MVS it's 2047 or 4095 (forget
> which) but on many systems it is smaller.

This limit is set by the parameter MAXDATAFILES at database creation time and is OS limited as stated above.

---
Neil Greene
Senior Oracle DBA / Unix System Administrator
SHL Systemhouse, Inc.  	LA Outsourcing Center 	
<HREF=mailto:ngreene_at_shl.com>