Unlike permanent tables, temporary tables and their indexes do not automatically allocate a segment when they are created. Instead, segments are allocated when the first INSERT (or CREATE TABLE AS SELECT) is performed. This means that if a SELECT, UPDATE, or DELETE is performed before the first INSERT, the table appears to be empty. In otherword, nologging is default. If you rollback a transaction, the data you entered is lost, although the table definition persists.

Because the data in a temporary table is, by definition, temporary, backup and recovery of temporary table data is not available in the event of a system failure. To prepare for such a failure, you should develop alternative methods for preserving temporary table data.

LS

"640KB ought to be enough for anybody." - Bill Gates, 1981



----- Original Message ----
From: Kopejtko Martin Ing. <oracledba-ezmlmshield-x37027687.[Email address protected]
To: LazyDBA Discussion <[Email address protected]
Sent: Monday, January 7, 2008 8:21:16 AM
Subject: nologging

> Hi all,
>
> is it possible to UPDATE global temporary table with nologging clause?
> Any way ...
>
> Thanks!
> Martin
###########################################

Zprava byla pred odeslanim testovana systemem F-Secure Anti-Virus for Microsoft Exchange.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

Oracle LazyDBA home page