Re: How to change MAXDATAFILES?

From: Muralidhar Prabhakaran <muralip_at_earthlink.net>
Date: Mon, 14 Jan 2002 04:00:36 GMT
Message-ID: <EJs08.29006$Vz3.2930619@newsread2.prod.itd.earthlink.net>

No those are not the right steps.

Run alter database backup controlfile to trace command Edit the oraxxxx.trc in the udump directory to change the maxdatafiles parameter.
Shutdown the database
startup in nomout mode
run this script
and then startup the database

Murali
"Eric" <h9515895_at_sinatown.com> wrote in message news:a1tja5$pno$1_at_hfc.pacific.net.hk...
> Hi,
>
> I want to change the MAXDATAFILES in the init.ora file. As I know, I need
to
> re-create the control file. What is the correct steps to change it? Pls
> check it for me ... Thanks
>
> 1) change the parameter MAXDATAFILES in init.ora
> 2) startup nomount
> 3) alter database create controlfile to '/directory'
> 4) alter database open
>
> Pls, correct my wrong step and give me advices
>
> Thanks again
> Eric Wong
>
>
Received on Sun Jan 13 2002 - 22:00:36 CST