TOAD shows not correct MV Log names in both tabs (Materialized View and Materialized View Logs),
shows Base Table Name instead of MV Log name.
It can mislead DBA and developers.
Hi Sergey,
When you create a MV Log on a table called, for example, MY_TABLE, Oracle creates a table called MLOG$_MY_TABLE.
As I understand from the support case you opened, you'd like to see MLOG$_MY_TABLE displayed here in the Schema Browser instead of just MY_TABLE.
It's been this way in Toad for about 20 years now (as long as we've supported Materialized View Logs). I've also looked in other products (SQL Developer) and it's displayed the same way there too.
It says "Materialized View Logs" in a couple of places in the screen shot. I don't understand the confusion here. You know the Materialized View Log on a table is always called MVLOG$_(table_name).
To me, MVLOG$_ is just extra letters that will get in the way. I'm open to feedback from others on this.
-John
Hi John,
Yes, you are right, SQL Developer has the same bug.
Let's check it step by step.
There is a base table.
You can create materialised view based on it.
Materialised View Log can be created or not, depending on SQL command.
And base table and MV Log are different entities, have very different structure and content.
And also the names are different. You have to choose the MV name, but you cannot do that for MV Log, it is always generated by the system.
By the way, several different MV's can be created on one base table, they will have different names.
But SQL Developer in this case will show all MV Logs with identical names, which is wrong from system dictionary point of view.
And it really misleads developers and DBA's.
See att for one example snapshot from SQL Developer.
Best regards,
Sergey
Yes, but in Toad, when you are looking at MV Logs, you are in the area of the Schema Browser which is labelled "Materialized View Logs". When you are looking at Tables, you are in the area of the Schema Browser labelled "Tables". This eliminates the confusion.
How about this?
The Schema Browser allows you to right-click a column header here to add other columns. I can add one to the next beta for "Log Table". Then you can see the log table listed beside the base table. Would that work for you?
-John
Hi John,
yes, in Schema Browser – „Materalized View“, Tab „Uses Materialized View Log” you can see the Name of base table, but not the Name of MV Log.
See att for screenshot.
Best regards,
Sergey
Hi Sergey,
Ok, I can specify both Base Table and Log Table there in the next beta.
-John
Hi John,
yes, it would be good.
Best regards,
Sergey
Hi John,
terrible Thanks for your assistance!
Best regards,
Sergey
1 Like