Hi Agus,

In order to move you system tablespace you have to do the next things:
1.- verify the datafiles location for the system tablespace
2.- always take a backup when you are going to changes your database physical structure.
3.- shutdown your instance using either immediate or normal option.
4.- move or copy all your datafiles beloging to the system tablespace to the target directory.
5.- mount your database " startup mount"
6.- execute " alter database rename file 'C.:\ORACLE\...\SYSTEM01.DBF' to 'D:\oracle\...\SYSTEM01.DBF'; "
7.- execute " alter database open"
8.- verify the location of your datafiles.
9.- if it is possible, is recommended to take full backup , if not at least take a backup of your control files.

Hope this helps.

Gilson

----- Original Message -----
From: "Agus Purwanto " <oracledba-ezmlmshield-x59405496.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Subject: Move tablespace System
Date: Wed, 18 May 2005 07:14:12 +0700

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


--
___________________________________________________________
Sign-up for Ads Free at Mail.com
http://promo.mail.com/adsfreejump.htm


Oracle LazyDBA home page