Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Argh! reached Max 32 files per DB ! Now what ?
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 Fri Aug 08 1997 - 00:00:00 CDT