Re: Temp tbs with no temp file

I don't do that, but I would write a script to check the alert log periodically - and I don't like the 10g style WARNING notices because they tend not to get picked up by existing scripts.  Do you guys write script to check the existing of the tempfile? I think I need to add "ADD TEMPFILE" in my startup script.

Regards,
Sinardy

• Original Message ----- From: "Kirtikumar Deshpande" <kedeshpande_at_yahoo.com> To: "Oracle-L" <oracle-l_at_freelists.org>; <all_about_oracle_at_hotpop.com> Sent: Tuesday, July 05, 2005 3:52 AM Subject: Re: Temp tbs with no temp file

> Hi,
> Sorry I did not catch all the messages in this thread...
>
> So, is this temporary tablespace the default at database level?
>
> Look in DATABASE_PROPERTIES to check which tablespace is the default
temporary
> tablespace.
>
> select *
> from database_properties
> where property_name = 'DEFAULT_TEMP_TABLESPACE';
>
> If the default temp tablespace is the same that does not have any
tempfiles associated
> with it, then your sorting, so far, did not need to write to sort segments
and was
> completing in memory (same for the hash joins). If those segments needed
to be written to
> temp tablepace without tempfiles you would have seen following error:
>
> ORA-25153: Temporary Tablespace is Empty
>
>
> HTH,
>
> Cheers!
>
> - Kirti
>
>
> --- Sinardy <all_about_oracle_at_hotpop.com> wrote:
>
> > My DB without temp file (tablespace) for like two months during this
time
> > where are the sorting being carried out? I know add temp file will work
but
> > just curious how come I can work without temp file.
> >
> > regards,
> > Sinardy
> >
> >
> >
>
>
>
> __________________________________
> Yahoo! Mail
> Stay connected, organized, and protected. Take the tour:
> http://tour.mail.yahoo.com/mailtour.html
>
>

--
http://www.freelists.org/webpage/oracle-l



-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com

--
http://www.freelists.org/webpage/oracle-l