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

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 Received on Thu Aug 14 1997 - 00:00:00 CDT