Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Help: Tuning "temporary" tables

Re: Help: Tuning "temporary" tables

From: Keith Boulton <boulkenospam_at_globalnet.co.uk>
Date: 1997/12/07
Message-ID: <348b074e.36306696@read.news.global.net.uk>#1/1

On Thu, 04 Dec 1997 12:38:55 +0200, Muli Koppel <mkoppel_at_barakitc.co.il> wrote:

>
> In Oracle8 you could have use the NOLOGGING option for that table, which is
>exactly what you're looking for. (But I assume you're still riding on 7)
>
>

According to the documentation, this attribute affect only to the table creation, direct load sql*loader and direct load insert statements.

What you would like to do is specify that oracle should treat the table in the same way as a table stored in a temporary tablespace. Received on Sun Dec 07 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US