Re: Temporary segment left over after failed distributed transaction?

Make temp tablespace offline and online when system is not being accessed by other users or temp tablespace is not in use. Regards
Rafiq

From: "Liu, Junxian" <Junxian.Liu_at_scottishpower.plc.uk> Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Subject: Temporary segment left over after failed distributed transaction? Date: Thu, 17 Aug 2000 08:56:35 -0800

Hi,

This is 7.3.4 on Sun Solaris platform.

We noticed that some temporary segments belonging to SYS have been left over. We suspect this happened after some distributed transactions have failed (but rolled back OK and no entries in DBA_2PC_PENDING nor in DBA_2PC_NEIGHBORS). One such case is the failure of CREATE TABLE A AS
(SELECT * FROM A_at_REMOTE) due to space problem.

Does anyone know how to clear out these temporary segments? Better still does anyone know how to avoid this happening again (apart from make sure no more space problem)?

Thanks in advance!

Junxian Liu

--
Author: Liu, Junxian
   INET: Junxian.Liu_at_scottishpower.plc.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).

________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com