Re: Question on MAXDATAFILES (limit of 30?)

Simon,

  You can recreate the controlfile to change this parameter as follows:

     	svrmgrl
	connect internal
	alter database backup controlfile to trace
	

  Exit from svrmgrl and cd to the trace directory. You'll find the latest trace file there will have a "script" that can be used for re-creating the control file. You can modify the maxdatafiles parameter and re-create the controlfile. A word of caution - good backup would be a GREAT idea.

Steve         

Simon Goland <sg_at_mda.ca> wrote in article <331F3E18.2ACF_at_mda.ca>...
> Solaris 2.5.1 and Oracle 7.3 environment.
>
> When I tried to add another datafile, I got an error message saying I
> cannot have more than 30 datafiles. Yet db_files in my init.ora is set
> to 1000, and MAXDATAFILES in the SQL create script is 50. What am I
> missing and how can I increase this limit of 30?
>
> Alternatively, if I cannot, and still need another datafile, any ideas
> or tips to make it easier on me? In theory, I will have to copy a
> datafile to a volume with more space and RESIZE it. But can I also
> delete an existing datafile completely?
>
> I would appreciate if you can also email the reply in addition to
> posting. Thanks,
> --
> [ Simon Goland B-)> sg_at_mda.ca ]
> [ Without action there is no change ]
>
Received on Fri Mar 07 1997 - 00:00:00 CST