RE: Move system, temp and undotbs1?
- From: Surendra.Tirumala@xxxxxx
- To: cichomitiko@xxxxxxxxx, cemail_219@xxxxxxxxxxx
- Date: Fri, 1 Apr 2005 09:06:45 -0500
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 =
control=20
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=20
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'=20
size <n>;
alter system set undo_tablespace=3Dundotbs2;
drop tablespace undotbs1 including contents and datafiles;
************************************************************************=
****
****************
Cheers
Dimitre
----- Original Message -----=20
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 =
take
> system, etc. offline? This is a 10g database.
>
> Thanks.
>
> _________________________________________________________________
> Don=92t 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=20
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
