���������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������
X-Declude-Sender: [EMAIL PROTECTED] [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 [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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: [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).
