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-----
From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 28, 2003 8:39 AM
To: Multiple recipients of list ORACLE-L
Subject: alter system dump logfile
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 !
