Re: Argh! reached Max 32 files per DB ! Now what ?

>Subject: Re: Argh! reached Max 32 files per DB ! Now what ?
>From: Nuno Souto <nsouto_at_acay.com.au>
>Date: Thu, 14 Aug 1997 21:15:46 +1000
>Message-ID: <33F2E8E2.1BB7_at_acay.com.au>
>
>Shafik A. Mahomad wrote:
>>
>> Hey guys ! I desperately need your help !
>>
>> I'm running Oracle Workgroup Server 7.1 on Win NT 3.51.
>>
>> The situation is this :
>>
>> One of the database files containing user indexes is filling up, so I
>> proceded to add one more file to it. Problem is, I got a message
>> saying that a limit of 32 files was reached so it was not possible to
>> extend the given tablespace.
>>
>> So how do I proceed from here ? Does 7.2 have the same limit ?
>>
>> I have maybe a week or two before the tablespace fills up on me.
>>
>> Thanks for your help !
>
>
>Easy.
>
>Read the manual (I hate the way it sounds, but it's true) on the section
>about CREATE CONTROLFILE. All you need to do is create a new control
>file with MAXFILES set to a high number (say, 128, don't go overboard
>here!). Then set the db_files parameter in init.ora to a higher number
>as well and you'll be fine.
>
>You need to follow the instructions on the CREATE CONTROLFILE bit VERY
>CAREFULLY, otherwise you may end up without a database! Doesn't hurt to
>backup either, just in case...
>
>HTH
>Nuno Souto
>nsouto_at_acay.com.au
>

 Is that possible? to increase the number of datafiles with a couple of changes in the control and parameter file? something to look into. Thanx

Satar Naghshineh
Entry-level Oracle DBA Received on Thu Aug 14 1997 - 00:00:00 CDT