YOU CAN NOT OFFLINE SYSTEM TABLESPACE !

-----Original Message-----
From: Patterson Joel
[mailto:oracledba-ezmlmshield-x18459065.[Email address protected]
Sent: Wednesday, May 18, 2005 2:53 PM
To: LazyDBA Discussion
Subject: RE: Move tablespace System

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




--------
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





---------------------------------------------------------------------------------------------------------------

orange mail - Connect to your e-mail anywhere with any handset
http://www.orange.co.il/web/corporate/app/omailadviser/webform1.aspx

---------------------------------------------------------------------------------------------------------------
This message contains information that may be confidential or privileged.
If you are not the intended recipient, you may not use, copy or disclose
to anyone any of the information in this message. If you have received
this message and are not the intended recipient, kindly notify the sender
and delete this message from your computer.


Oracle LazyDBA home page