Look for any process/sql on your system which is resulting in a cartesian
join using lot of temp tablespace....
Regards
MOHAMMAD RAFIQ
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Thu, 02 Aug 2001 23:40:24 -0800
Hi Gurus,
I have a problem, perhaps someone can shed some light on this, please,
I have a temporary Tablespace, which keeps on running out of space. At first
I would increase the size, yet it still keeps filling up. Failing to be able
to extend, until I increase it again.
The object in the tablespace is owned by SYS and is called 11.2
Does anyone have any idea what is causing this and where it originates from,
and what the object is, because it is not a table?(As far as I can see).
The OS platform is Windows 2000
Oracle Version is 8.1.7.
Thank You
Denham
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Denham Eva
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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 FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mohammad Rafiq
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
