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: Tablespaces - datafiles

RE: Tablespaces - datafiles

From: gmei <gmei_at_incyte.com>
Date: Tue, 11 Mar 2003 06:30:04 -0800
Message-ID: <F001.00565EB8.20030311063004@fatcity.com>


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).
Received on Tue Mar 11 2003 - 08:30:04 CST

Original text of this message

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