Re: Number of files in an Instance?

From: Frank Kobylanski <this_person_at_thisplace.com>
Date: 1997/03/06
Message-ID: <5fn7ad$c5v$1@newsin-1.starnet.net>#1/1

John <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

John,

Usual caveats (backup your db, then back it up again ;-)) 1. Shutdown and did I mention backup
2. alter database backup control file to trace - generates an ascii text version of your controlfile, it will be in user_dump_dest, ora_nnnnn.trc.
3. use your favorite editor to strip out all the comment stuff 4. change the maxdatafiles parameter to what you want it to be and save as a .sql file..
5. shutdown your db
6. run this script

For further info, check chap 6 (Managing Control Files) of the Server Admin Guide.

HTH, Frank Received on Thu Mar 06 1997 - 00:00:00 CST