Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question
    
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 ? –  Gary Mar 12 '10 at 5:41
    
Yes, I'm sure that they are global temporary tables in my schema. –  Sarith Mar 12 '10 at 7:43
add comment

1 Answer

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
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.