alter tablespace USA3K_MID read only;
alter tablespace USA3K_MID offline;

Physically move or copy files on OS level.

alter database rename file 'D:\ORADATA\AIR09\USA3K_MID02.DBF' to
'E:\ORADATA\AIR09\USA3K_MID02.DBF';
alter database rename file 'D:\ORADATA\AIR09\USA3K_MID01.DBF' to
'E:\ORADATA\AIR09\USA3K_MID01.DBF';
alter database rename file 'D:\ORADATA\AIR09\USA3K_MID03.DBF' to
'E:\ORADATA\AIR09\USA3K_MID03.DBF';

alter tablespace USA3K_MID online;
alter tablespace USA3K_MID read write;



-----Original Message-----
From: Agus Purwanto
[mailto:oracledba-ezmlmshield-x59405496.[Email address protected]
Sent: Tuesday, May 17, 2005 8:14 PM
To: LazyDBA Discussion
Subject: Move tablespace System

Hi,

how to move tablespace system in another disc. Ex. from C: to D:


thanks
ags


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html



Oracle LazyDBA home page