Rename System tablespace file
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
Re: Rename System tablespace file
Quote:
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
Re: Re: Rename System tablespace file
Quote:
Originally posted by 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
Problem resolved.
thanks
regards
ramji