Can we do this for SYSTEM TS?

Regards

Deepak
----- Original Message -----
From: "Patterson Joel "
<oracledba-ezmlmshield-x18459065.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Wednesday, May 18, 2005 6:22 PM
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


Oracle LazyDBA home page