Re: temporary tablespace using tempfile

[Connor McDonald]

depends but tpically, a lot less.

Exceptions are easy to find - eg, you need undo for a
global temp table because you are allowed to
'rollback' etc

hth
connor

 --- Jos [EMAIL PROTECTED] wrote:  
 List,
 
 When with temporary tablespace using tempfile, does
 Oracle generate redo/undo information for temporary
 segments?
 
 Jos
 
  
 
 
 
 -
 Yahoo! Mobile
 - Exchange IMs with Messenger friends on your
 Telstra or Vodafone mobile phone. 

=
Connor McDonald
web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: [EMAIL PROTECTED]

GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will 
sit in a boat and drink beer all day

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

Re: temporary tablespace using tempfile

[Jos]

Connor,
Thanks for your reply. Where can I find these information about what temporary segment will generate redo/undo? 
Jos
Connor McDonald [EMAIL PROTECTED] wrote:
"depends" but tpically, a lot less.Exceptions are easy to find - eg, you need undo for aglobal temp table because you are allowed to'rollback' etchthconnor--- Jos <[EMAIL PROTECTED]>wrote:   List,  When with temporary tablespace using tempfile, does Oracle generate redo/undo information for temporary segments?  Jos  - Yahoo! Mobile - Exchange IMs with Messenger friends on your Telstra or Vodafone mobile phone. =Connor McDonaldweb: http://www.oracledba.co.ukweb: http://www.oaktable.netemail: [EMAIL PROTECTED]"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"!
__Do You Yahoo!?Everything you'll ever need on one web pagefrom News and Sport to Email and Music Chartshttp://uk.my.yahoo.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: =?iso-8859-1?q?Connor=20McDonald?=INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Yahoo! Mobile
- Exchange IMs with Messenger friends on your Telstra or Vodafone mobile phone.