Re: Number of Datafiles

>

Hi,

   I have had to adjust the number of datafiles before. It was on ver 7.0.16    I used the command
   ALTER DATABASE dbname BACKUP CONTROLFILE TO TRACE NORESETLOGS;    to make a copy of my control file. I edited my pfile to increase    the number of dbfiles, and edited the trace file to increase the max    number of files and remove the extra lines at the top of the trace file.    I also add a line for the pfile location after the startup nomount line    in the trace file. Then I shut down the instance, rename the existing    control files, and run the trace file from within oracle. This will recreate    the control files, and reset the max number of files. I then shutdown the    instance and start it up again using our normal startup. These are the steps    that oracle provide me and they are also in one of the manuals. Not counting    the amount of time it takes to do a backup, This process takes about 15    minutes. Hope this helps.

   Darrel Johnson
>
> Wish you a very very happy new year.
>
> In our database, I found out that the number of existing datafiles
> is 30. Now every time I try to add a new datafile, I get an oracle error
> saying that the number of datafiles has exceeded.
> Is there a way to increase this value?
> Our environment is :
> U6000/500 - UNIX
> Oracle 7.0.12
>
> Thanks for any suggestion.
>
> BBT
> _______________________________________________________________
> Bharat Bhushan Tripathi
> Senior Software Engineer Ph. (011-8)-562585, 562588-92
> Tata Unisys Limited, Fax. (011-8)-56584
> Computer Consultancy Division, Tlx. 08905-211 TULN IN
> SDF#A/5-A/6,
> Noida Export Processing Zone, Noida - 201 305 INDIA

> E-Mail. bbt_at_celtics.tulnepz.unisys.com
> _______________________________________________________________
>
Received on Fri Dec 29 1995 - 10:06:46 CST