RE: Locally managed temp tablespace

Alex,

Check out the documentation under 'CREATE TEMPORARY TABLESPACE'.

It includes links to the concepts manual and will explain all.

Jared

On Fri, 7 Jul 2000, Alex Hillman wrote:

> What is a tempfile?
>
> Alex Hillman
>
> -----Original Message-----
> Sent: Friday, July 07, 2000 12:35 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi Chuck,
>
> Is there any reason why you would NOT want to use a tempfile temporary
> tablespace to get implicit nologging functionality instead?
>
> Regards,
> Steve Adams
> http://www.ixora.com.au/
> http://www.oreilly.com/catalog/orinternals/
> http://www.christianity.net.au/
>
>
> -----Original Message-----
> From: Chuck Hamilton [SMTP:chuck_hamilton_at_yahoo.com]
> Sent: Friday, July 07, 2000 6:44 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Locally managed temp tablespace
>
> Is there any reason why you would NOT want to set a locally managed TEMP
> tablespace to "no logging"?
>
>
>
>
> ---------------------------------
> Do You Yahoo!?
> Send instant messages & get email alerts with Yahoo! Messenger. << File:
> ATT00059.htm >>
> --
> Author: Steve Adams
> INET: steve.adams_at_ixora.com.au
>
> 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).
>

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-) Regence BlueCross BlueShield of Oregon
jkstill_at_bcbso.com - Work - preferred address Received on Mon Jul 10 2000 - 12:37:46 CDT