Re: Number of files in an Instance?

To increase MAXDATAFILES for an existing database you need to issue CREATE CONTROLFILE statement.
As far as I know, Oracle Installer on some platforms (i.e. HP-UX) does not prompt you for MAXDATAFILES when you choose to create a new database. If default MAXDATAFILES value is too low for your databases, you can force Oracle Installer to use your value by editing Oracle supplied file cnfg.orc in $ORACLE_HOME/rdbms/install/rdbms directory (V7.3) or $ORACLE_HOME/rdbms/install directory (V7.2). Simply add line MAXDATAFILES nnn to create database command.

Solomon.Yakobson_at_entex.com

In article <331EF827.146_at_cyberway.com.sg>,   johnli_at_cyberway.com.sg wrote:
>
> > S. Snadow wrote:
> >
> > Is there a limit to the number of files that can be in an Oracle 7.3
> > instance?
>
> I believe that when you create a database, you have to specify the
> MAXDATAFILES. Failure to do so will limit the number of files to the
> default 30 (Oracle 7.1.6, Digital Unix) and I have not figure a way to
> increase this limit after the database is created (DB_FILES does not
> work!!!).
>
> John

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet