Surendra is correct. The datafiles are NOT opened in mount state. The Controlfile gets read in MOUNT state. Oracle doesn't even check the existence of the datafiles until it tries to OPEN. With the DB in MOUNT state, use the "alter databae rename datafile 'oldname' to 'mewname' >This AFTER you (as wad advised) cp the file to the new location. You do NOT have to recreate the controlfile. To change maxdatafiles, maxlogmembers, etc you would need to recreate..... -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Surendra.Tirumala@xxxxxx Sent: Friday, April 01, 2005 8:07 AM To: cichomitiko@xxxxxxxxx; cemail_219@xxxxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx Subject: RE: Move system, temp and undotbs1? You can move the system and undo tablespaces too.... in mount stage... Surendra Tirumala Database Administrator Division of Technology Services Education Cabinet Commonwealth of Kentucky Ph: (502) 564-6949x380 Surendra.Tirumala@xxxxxx -----Original Message----- From: cichomitiko gmail [mailto:cichomitiko@xxxxxxxxx] Sent: Friday, April 01, 2005 8:44 AM To: cemail_219@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx Subject: Re: Move system, temp and undotbs1? You cannot move the system tablespace, you have to re-create the =3D control=3D20 files to change the system data file's path. ************************************************************************ =3D **** ************* To move the temp tablespace: create tablespace temp1 datafile 'new_mount_point_data_file_name' size = =3D <n>; then ... alter user <username> temporary tablespace temp1; --> for the users =3D that=3D20 have temporary tablespace temp! then ... drop tablespace temp including contents and datafiles; ************************************************************************ =3D **** *************** To move the undo tablespace: create undo tablespace undotbs2 datafile =3D 'new_mount_point_data_file_name'=3D20 size <n>; alter system set undo_tablespace=3D3Dundotbs2; drop tablespace undotbs1 including contents and datafiles; ************************************************************************ =3D **** **************** Cheers Dimitre ----- Original Message -----=3D20 From: "J. Dex" <cemail_219@xxxxxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Sent: Friday, April 01, 2005 5:23 AM Subject: Move system, temp and undotbs1? > How do you move the system, temp and undotbs1 from one mount point to > another? I was able to move other tablespaces, but I know you can't = =3D take > system, etc. offline? This is a 10g database. > > Thanks. > > _________________________________________________________________ > Don=3D92t just search. Find. Check out the new MSN Search! > http://search.msn.click-url.com/go/onm00200636ave/direct/01/ > > -- > //www.freelists.org/webpage/oracle-l=3D20 -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l