| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_ky.gov
-----Original Message-----
From: cichomitiko gmail [mailto:cichomitiko_at_gmail.com]
Sent: Friday, April 01, 2005 8:44 AM
To: cemail_219_at_hotmail.com; oracle-l_at_freelists.org
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
> 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/ > > -- > http://www.freelists.org/webpage/oracle-l=20
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Fri Apr 01 2005 - 09:10:36 CST
 |
 |