UNSUPPORTED Value in Sql_redo, Operation Columns of V$Logmnr_contents
Last updated on OCTOBER 25, 2017
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Information in this document applies to any platform.
***Checked for relevance on 22-May-2013***
From v$logmnr_contents, SQL_REDO column value is needed to analyze transaction but the value is 'Unsupported'.
Operation - Unsupported
OPERATION_CODE - Unsupported
SQL_REDO - Unsupported
Following items are not supported with the logminer utility.
1) Simple and nested abstract datatypes (ADTs)
2) Collections (nested tables and VARRAYs)
3) Object Refs
4) Index organized tables (IOTs)
5) CREATE TABLE AS SELECT of a table with a clustered key
None of the above five scenarios meet your scenario.
Step 1. Assume table TB_M80_MATL010 exists in Schema 'SCOTT'
Step 2. switch logfile
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms