Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 7 :moving tablespaces
On Fri, 30 May 2003 11:13:29 +0200, "Darksheep's Revenge" <vi_at_cal.it>
wrote:
>Hi,
>To free more space, I need to move tablespaces (data,index,rbs,system and
>temp) from an HD to another.
>Can anyone explain to me step by step how to do this work whithout loosing
>data?
>
>In Storage Manager there is not way to do a "move".
>
>system is a Unix 4.0d over a digital aplha server 1200; oracle 7
>
>tnx a lot.
>
>
shut the database, move the tablespaces
startup mount
alter database rename '<oldfile>' to '<newfile>'
alter database open
or
alter database backup controlfile to trace
edit the tracefile
recreate the controlfile by running the tracefile
and -oh yes- please do not cross and multipost
Sybrand Bakker, Senior Oracle DBA
To reply remove -verwijderdit from my e-mail address Received on Fri May 30 2003 - 05:13:25 CDT