Temp tablespace Full

From: nilesh kumar <nileshkum_at_gmail.com>
Date: Wed, 6 Nov 2013 22:18:30 +0530
Message-ID: <CACzEWSUffKv0KeruXtmcPEikXboPUH6HdOC5LAES_NG_UeeObg_at_mail.gmail.com>



Hello All,

Hope every one is doing good!!

I have a question.

Can select 1 from dual can cause the Temp tablespace Full ? I see from Toad several sessions of a user executing select 1 from dual causing the Temp space full.
Can some one of you put some light on this one.

-- 
Thanks & Regards
Nilesh
Oracle DBA (sqlplus "/as sysdba" is my world)


"As our circle of knowledge expands, so does the circumference of darkness
surrounding it."--Einstein
"All men die, few men ever truly live" -- Braveheart
"You can get help from teachers, but you are going to have to learn a lot
by yourself, sitting alone in a room." --Dr. Seuss
"Know me for what I do and for not what I am. Judge me for what I can do
and not for what I have done."-Unknown
"Don't walk in front of me, I may not follow. Don't walk behind me, I may
not lead. Just walk beside me and be my friend."- Albert Camus
"Never argue with an idiot. They drag you down to their level and then beat
you with experience." - Unknown -- http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 06 2013 - 17:48:30 CET

Original text of this message