Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to change MAXDATAFILES?
"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
What's your Oracle Version?
If you use Oracle7, you have to recreate the controlfile, if Oracle 8
just change the db_file in init.ora.
Received on Mon Jan 14 2002 - 04:00:08 CST