UNSUPPORTED Value in Sql_redo, Operation Columns of V$Logmnr_contents
(Doc ID 282994.1)
Last updated on MARCH 12, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 9.2.0.5 and laterInformation in this document applies to any platform.
Symptoms
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.
TESTCASE
Step 1. Assume table <TABLE_NAME> exists in Schema 'SCOTT'
Step 2. switch logfile
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |