Follow the below steps to move the system data files different location.

1. Shut down the database.
2. Use an operating system command to move the files.
3. Mount the database.
4. Execute the ALTER DATABASE RENAME FILE command.
5. Open the database.

Thanks & Regards
Karthik

-----Original Message-----
From: Deepak Panda
[mailto:oracledba-ezmlmshield-x35219777.[Email address protected]
Sent: Tuesday, May 31, 2005 3:50 PM
To: LazyDBA Discussion
Subject: Re: Move tablespace System

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



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

Confidentiality Statement:

This message is intended only for the individual or entity to which it is addressed. It may contain privileged, confidential information which is exempt from disclosure under applicable laws. If you are not the intended recipient, please note that you are strictly prohibited from disseminating or distributing this information (other than to the intended recipient) or copying this information. If you have received this communication in error, please notify us immediately by return email.


Oracle LazyDBA home page