 Log Miner and Lob datatypes [message #118036] |
Mon, 02 May 2005 15:54 |
jamesstange
Messages: 1
Registered: May 2005
Location: Saint Louis, Mo, U.S.A
|
Junior Member |
|
|
Does anyone understand how to extract changes to LOB datatypes using log miner? Both the 9i and 10g manuals claim to support LOB column when the database has supplemental logging. The 9i manual describes the following columns:
redo_sql - containing a portion of the changed lob
sql_column_type - type of lob/long column
sql_column_name - name of the changed lob column
redo_length - length of data in the redo_sql column
redo_offset - position of changed data in lob column
In my attempts to extract changes to LOB columns in 9R2 (9.2.0.1) these columns never seem to contain any data ever. Furthermore, I just read the 10g manuals that state that these columns are deprecated. The 9i and 10g manuals also state that mine_value functions do not work with LOBS either. Has anyone figured out how to work with LOBS and Log miner? Thanks.
James Stange
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
