Path: news.cambrium.nl!textnews.cambrium.nl!feeder2.cambriumusenet.nl!feed.tweaknews.nl!postnews.google.com!m38g2000yqd.googlegroups.com!not-for-mail From: "codefragment@googlemail.com" Newsgroups: comp.databases.oracle.server Subject: Re: Temporary table use and the redo log Date: Wed, 9 Sep 2009 05:28:49 -0700 (PDT) Organization: http://groups.google.com Lines: 18 Message-ID: <3e8a48c3-5386-42fc-9f5e-7296ae9e3923@m38g2000yqd.googlegroups.com> References: <4b3fdc8a-6ad1-4275-8d5a-200ecf45bdf0@a21g2000yqc.googlegroups.com> <8f7154be-0b5b-41ed-a773-0ad38cf06583@j39g2000yqh.googlegroups.com> NNTP-Posting-Host: 81.137.172.146 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 X-Trace: posting.google.com 1252499329 26730 127.0.0.1 (9 Sep 2009 12:28:49 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Wed, 9 Sep 2009 12:28:49 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: m38g2000yqd.googlegroups.com; posting-host=81.137.172.146; posting-account=pxdg5QoAAABxfENvItfA06OUPHUwuomY User-Agent: G2/1.0 X-HTTP-Via: 1.1 cgate:8080 (squid/2.7.STABLE5) X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729),gzip(gfe),gzip(gfe) Xref: news.cambrium.nl > - This also means that you can't access an object modified by direct- > path inserts within the same transaction which needs to be considered > for your process logic. You need to commit to access the inserted the > rows which means a "on commit delete rows" temporary table doesn't > make sense with a direct-path insert operation, since after the commit > the data will be gone. Thanks for the reply. I gather you can have Autonomous Transactions within a procedure, so I could: - start a transaction, - load the temporary table up, - do my selects - commit the transaction, then carry on with the rest of the procedure? Any views on that?