Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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

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.