Re: How to change MAXDATAFILES?

here is what i would do :

1. take a backup of controlfile using alter database backup controlfile to trace command.
2. change maxdatafiles parameter to whatever value that needs to be increased to.
3. shutdown database, take a cold backup just to be safe.
4. change db_files parameter to the increased value of init<sid>.ora file
5. startup nomount
6. create controlfile
7. open the database
8. take a backup of controlfile immediately for backup purpose.

-Stan

Eric wrote:

> 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 - 23:51:17 CST