Oracle-L: RE: alter system dump logfile

From: <Alexander.Feinstein_at_mitchell1.com>
Date: Thu, 28 Aug 2003 14:39:26 -0800
Message-ID: <F001.005CDCEF.20030828143926@fatcity.com>

Here is for LAYER 11. Full list is too long.

Layer 11:  KCOCODRW -  Row
opcode 1 :  KDOIUR  - interpret undo redo
opcode 2 :  KDOIRP  - insert row  piece
opcode 3 :  KDODRP  - drop row piece
opcode 4 :  KDOLKR  - lock row  piece
opcode 5 :  KDOURP  - update row piece
opcode 6 :  KDOORP  - overwrite row piece
opcode 7 :  KDOMFC  - manipulate first column
opcode 8 :  KDOCFA  - change forwarding address
opcode 9 :  KDOCKI  - change cluster key index
opcode 10 :  KDOSKL  - set key links
opcode 11 :  KDOQMI  - quick multi-insert (ex. insert as select...)

opcode 12 : KDOQMD - quick multi-delete opcode 13 : KDOTBF - toggle block header flags

Alex.

-----Original Message-----
Sent: Thursday, August 28, 2003 8:39 AM
To: Multiple recipients of list ORACLE-L

Hi all,
as mentioned in Metalink article, one can use "ALTER SYSTEM DUMP LOGFILE ... LAYER 11 OPCODE 3" to dump deleted rows from archived logs. does anyone know
1. what others layers are and what they correspond to? 2. what other opcodes are and what they relate to? TIA
Raj

Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
INET: Alexander.Feinstein_at_mitchell1.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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 Thu Aug 28 2003 - 17:39:26 CDT