I want to set DB_CREATE_FILE_DEST in Oracle9i,I know it need to modify file init.ora,but there is not the file init.ora in my oracle directory,it is only file init.ora.3520059515, it's path is C:\oracle\admin\dataware\pfile\init.ora.3520059515 ,so I add
db_create_file_dest=C:\TEMP into the file. Then I shutdown the database,and open it again,but I find the parameter of DB_CREATE_FILE_DEST is not work,
SQL> show parameter db_create_file_dest

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_create_file_dest string

Why? How to solve it?

You can do it by,
ALTER SYSTEM SET db_create_file_dest = 'C:\TEMP';

It will do.

Sujit Ku. Mahapatra