Originally posted by ramji
Dear all,

I hv created new DB SID : maxlive
and also create tablespace system ---> file "/oracle/maxprd1/system01.dbf"
Now I will try to change path from

file "/oracle/maxprd1/system01.dbf" to

file "/oracle/maxprd1/maxlive/system01.dbf"

after database creation
How to change system file path ?
Please Advice
Regs
ramji
i have done as per yr advice but at the time of db open
following error

alter database open
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/oracle/maxprd1/maxlive/system01.dbf'
Please advice