Re: NOLOGGING

From: Joe Testa <teci_at_the-testas.net>
Date: Sun, 02 Sep 2001 04:39:20 -0700
Message-ID: <F001.003805BE.20010902043617@fatcity.com>

ÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌÌ
X-Declude-Sender: teci_at_the-testas.net [63.26.83.125]

X-Declude-Spoolname: D19570e0.SMD
X-Note: This E-mail was sent from 1cust125.tnt1.circleville.oh.da.uu.net. ([63.26.83.125]).
X-Note: Please send abuse reports to vei-abuse_at_vei.net.

off the top of my head:

no nothing will be lost with a few exceptions(see docid 147474.1 in metalstink):

here the operations for which nologging/unrecoverable work, everything else IS LOGGED:

The following operations can make use of no-logging mode:

        direct load (SQL*Loader) 
        direct-load INSERT 
        CREATE TABLE ... AS SELECT 
        CREATE INDEX 
        ALTER TABLE ... MOVE PARTITION 
        ALTER TABLE ... SPLIT PARTITION 
        ALTER INDEX ... SPLIT PARTITION 
        ALTER INDEX ... REBUILD 
        ALTER INDEX ... REBUILD PARTITION 
        INSERT, UPDATE, and DELETE on LOBs in NOCACHE NOLOGGING mode

stored out of line

joe

VIVEK_SHARMA wrote:
>
> CASE In the Following
> Step 0 Cold Backup of Database Taken
> Step 1 Object Exists in LOGGING .
> Step 2 Object is Altered to NOLOGGING
> Step 3 Transactions Occur on the Object
> Step 4 Object is Altered back to LOGGING mode
> Step 5 Database Crashes & Recovery Done
>
> Qs. Will the Object have Some Data Missing , both in case the Object is
> a Table or Index ?
>
>

-- 
Joe Testa  
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
IM: n8xcthome or joen8xct
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  INET: teci_at_the-testas.net

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).

Received on Sun Sep 02 2001 - 06:39:20 CDT