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

The easiest way to create a new control file is to issue the sql command ' alter database backup controlfile to trace noresetlogs;' which will generate a trace file containing a create controlfile command in the user dump destination directory. Then all you have to do is edit the trace file, change the MAXDATAFILES parameter,delete the unnecessary commands in the trace file, and run the trace file.

You should read section 6 in the Administrator's Guide on managing control files, particularly the portion that addresses creating new control files. Iceman <rtefft_at_radix.net> wrote in article <5sfqib$qvv$1_at_news1.radix.net>...
> In article <5sf4fi$c40_at_duke.telepac.pt>, smahomad_at_mail.telepac.pt says...
> >
> >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 !
> >
> >
> >..Shafik.Mahomad.......................................................
> >... Deliriously happy with OS/2!! .....................................
> >......smahomad_at_mail.telepac.pt........................Lisbon, Portugal.
> >
> This is a database restriction, not a software one. Because the
> control files have a fixed number of entries for database filenames,
> (32 in your case, also the default on most systems) you cannot
> increase this without rebuilding your controlfile. Check out
> the CREATE CONTROLFILE command in the SQL or DBA manuals. You need
> to be VERY CAREFUL with this command as you will have to re-specify
> the names and sizes of all redo logs and database files in the
> nre CREATE CONTROLFILE command. Make sure you look it all up in
> the DBA views to get it right. I had to increase mine from
> 32 to 75, and later up to 100.
>
> Rich Tefft "Redundant data just isn't normal!"
>
>
Received on Mon Aug 11 1997 - 00:00:00 CDT