Home » RDBMS Server » Server Administration » Query LogMiner for clustered tables
icon5.gif  Query LogMiner for clustered tables [message #110536] Tue, 08 March 2005 09:14 Go to next message
samizn
Messages: 7
Registered: March 2005
Junior Member
Hi all,
I am trying to query the v$logmnr_contents to get the changes for a clustered table. I noticed that all the INSERT/UPDATE/DELETE was returned as UNSUPPORTED until I ran the following:

ALTER TABLE ... ADD supplemental log group ...

After I executed that query and only then, I began to get from the LogMiner the data that I expected (only for operation executed after the ALTER TABLE query of course).
Can anyone explain this behavior to me??

Thanks,
Sami.
Re: Query LogMiner for clustered tables [message #110538 is a reply to message #110536] Tue, 08 March 2005 09:20 Go to previous message
samizn
Messages: 7
Registered: March 2005
Junior Member
I forgot to mention that I am using Oracle 9201 for windowns.
Previous Topic: Usage in Temp-Tablespace
Next Topic: Heavy Update ( Update on Millions of Rows )
Goto Forum:
  


Current Time: Sat Jan 25 03:12:39 CST 2025