Re: moving temp datafile

From: Rotter Richard <rotter_at_aon.at>
Date: Sun, 23 Jan 2000 12:10:40 +0100
Message-ID: <388ae142$0$15382@SSP1NO17.highway.telekom.at>

Hi,

The way is:

Shutdown your database
Make a full backup of your database
move the tempfile to the new location (f.e.: mv /d01/temp.dbf /d02/temp.dbf)
startup your database with the mount option (startup mount)
rename the datafile in the database (alter database rename datafile '/d01/temp.dbf' to '/d02/temp.dbf';
alter database open

Richard Rotter
Oracle DBA
email: richard_rotter_at_mediaprint.at

Doug Cowles <dcowles_at_i84.net> schrieb in im Newsbeitrag: 388950b5.23879061_at_news.remarq.com...
> Is there a way to move temp to another disk (datafile), without
> re-creating it and regranting quota? i.e. on live database?
Received on Sun Jan 23 2000 - 05:10:40 CST