Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Move system, temp and undotbs1?

Re: Move system, temp and undotbs1?

From: cichomitiko gmail <cichomitiko_at_gmail.com>
Date: Fri, 1 Apr 2005 15:44:29 +0200
Message-ID: <02ff01c536c0$eed73870$1a03310a@IBME1D11967173>


You cannot move the system tablespace, you have to re-create the control files to change the system data file's path.


To move the temp tablespace:

create tablespace temp1 datafile 'new_mount_point_data_file_name' size <n>;

then ...

alter user <username> temporary tablespace temp1; --> for the users that have temporary tablespace temp!

then ...

drop tablespace temp including contents and datafiles;


To move the undo tablespace:

create undo tablespace undotbs2 datafile 'new_mount_point_data_file_name' size <n>;

alter system set undo_tablespace=undotbs2;

drop tablespace undotbs1 including contents and datafiles;


Cheers
Dimitre

> 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 take
> system, etc. offline? This is a 10g database.
>
> Thanks.
>
> _________________________________________________________________
> Donít just search. Find. Check out the new MSN Search!
> http://search.msn.click-url.com/go/onm00200636ave/direct/01/
>
> --
> http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Apr 01 2005 - 08:48:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US