1

I'm currently using Oracle 11g on RHEL5. I'm digging to see what are in the archived log files. After I query from v$logmnr_contents, I see many transactions of UNSUPPORTED operation.

What do these unsupported transactions mean? I think that it's the cause that make my database generates lots of archived logs. Moreover, I'm using global temporary table for generating reports. I discover that when I insert and delete from those temporary table, it also records in the archived log file.

How to do to reduce those recorded transactions?

Regards,

Sarith

Improve this question
2
  • Are you SURE they are global temporary tables ? There isn't another table of the same name in a different schema, or a view or synonym. Are you doing stuff with LOBs ? Commented Mar 12, 2010 at 5:41
  • Yes, I'm sure that they are global temporary tables in my schema. Commented Mar 12, 2010 at 7:43

1 Answer 1

Reset to default
1

The following operations are unsupported in Logminer, Oracle 11.

  • BFILE datatype
  • Simple and nested abstract datatypes (ADTs)
  • Collections (nested tables and VARRAYs)
  • Object refs
  • Tables using table compression
  • SecureFiles
Improve this answer

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.