Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Developer - Materialized View logs

Håkan ArpforsApr 8 2020 — edited Apr 17 2020

In a database, it is only possible to create one Materialized view log per table.

I have created a MV log for tables POHEAD and POROW, but I can see 3 versions in the tree.

If I look at the detail they all look very similar per table.

When I expand the database browser and the Materialized view log node I get the following:

pastedImage_0.png

How is this possible?

Is it some strange query that populates this node?

Regards

Håkan

Comments
Post Details
Added on Apr 8 2020
3 comments
609 views