move oracle 10 directory

huakaibird發表於2008-01-04
Oracle

move oracle from '/opt' to '/disk'

>shutdown

cp all files;

update environment.

update pfile,

change control files, background_dump_dest, core_dump_dest, user_dump_dest

sqlplus "/as sysdba"

> startup mount pfile='new'

>alter database rename file 'old' to 'new'

>alter database open

ok

[@more@]

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/545828/viewspace-996445/，如需轉載，請註明出處，否則將追究法律責任。

相關文章