Oracle database Moving tempfiles without shutdown
host mv temp26.dbf /temp/temp26.dbf
host ln -s temp26.dbf /temp/temp26.dbf
alter database tempfile 'temp26.dbf' online;
After 10g
alter database tempfile 'temp26.dbf' offline ;
host mv temp26.dbf /temp/temp26.dbf
alter database rename file 'temp26.dbf' to '/temp/temp26.dbf'
Before 10g
alter database tempfile 'temp26.dbf' offline ;
host mv temp26.dbf /temp/temp26.dbf
host ln -s temp26.dbf /temp/temp26.dbf
alter database tempfile 'temp26.dbf' online;
After 10g
alter database tempfile 'temp26.dbf' offline ;
host mv temp26.dbf /temp/temp26.dbf
alter database rename file 'temp26.dbf' to '/temp/temp26.dbf'
No comments:
Post a Comment