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

rtefft_at_radix.net (Iceman) wrote:

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

Try the following....

alter database backup controlfile to trace;

This will create a .trc file in the database's udump directory containing a CREATE CONTROLFILE statement for the current database. (Much easier than creating it yourself).

Increase the number of datafiles with a text editor and save the file.

With svrmgrl (or sqldba) shut down the database and then run this script. It will restart the database, change the control files, and re-open the database.

Hope this helps.

--
Chuck Hamilton
Sr. DBA
Keystone Mercy Health Plan
chuckh_at_dvol.com

Press CTRL+ALT+DEL to continue.