RE: Tablespaces - datafiles

You can do

1. Create a new temporary tablespace (say temp1)
2. Assign all user's TEMPORARY_TABLESPACE to temp1
3. Drop the old temporary tablespace, remove it's OS files.
4. Re-create the temporary tablespace using new OS file names
5. Re-Assign all user's TEMPORARY_TABLESPACE to this new temporary tablespace
6. Drop temp1 and remove it's OS files

HTH. Guang

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of LeRoy
> Kemnitz
> Sent: Tuesday, March 11, 2003 8:39 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Tablespaces - datafiles
>
>
> All -
>
> I am having a problem with the datafiles in a temporary tablespace. I
> need to move and rename three different datafiles in the
> tablespace. I
> am able to take them offline - no problem. I cna make the changes at
> the OS level. I am running on Unix. But I can't get the changes to
> show up in the OEM inorder to bring them back on-line.
>
> Do I need to remove all users from this tablespace before making these
> changes? The tablespace is temporary so does that make a difference?
> Any suggestions?
>
> LeRoy
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: LeRoy Kemnitz
> INET: lkemnitz_at_uwsa.edu
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: gmei
  INET: gmei_at_incyte.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).