Oracle Data Modeler Get Logical DataType Usage
Shows the usage of Logical DataTypes within Oracle Data Modeler:
You’ll need a Database (any Database that supports a JDBC driver should work). I used Oracle XE.
Choose Export to Reporting Schema: Setup acess to the database as required. When the export is complete. You’ll have a complete copy of your Design’s Metadata in the choosen database.
Login to you database, and run the following query:
select LT_NAME, count(LOGICAL_TYPE_NAME) Total from DMRS_ATTRIBUTES right outer join DMRS_LOGICAL_TYPES ON DMRS_ATTRIBUTES.LOGICAL_TYPE_NAME = DMRS_LOGICAL_TYPES.LT_NAME group by LT_NAME order by Total desc;
This will return the list of the Logical Types names and their usage amounts.
Last modified on 2016-04-27