I specify that triggers are not to be processed for Reverse Engineering or Model Update. We are only interested in entities and relationships to build an ERD. But the following code is executed for every trigger:
FROM SYS.ALL_TRIGGER_COLS u, SYS.ALL_TAB_COLS c
WHERE u.TRIGGER_OWNER = ‘APSI’
AND u.TRIGGER_NAME = ‘SAFETY_SETPOINT_SI_SPT_BIUDS’
AND u.TABLE_OWNER = ‘APSI’
AND u.TABLE_NAME = ‘SAFETY_SETPOINT_SI’
AND u.COLUMN_LIST = ‘YES’
AND u.TABLE_OWNER = c.OWNER
AND u.TABLE_NAME = c.TABLE_NAME
AND u.COLUMN_NAME = c.COLUMN_NAME
AND c.HIDDEN_COLUMN = ‘NO’
We have a lot of triggers, so this takes a lot of time. If an object is not of interest, nothing should be done. I should see only the selected objects being processed in the log.
In my secondary issue, I define aliases. What objects to process is part of the definition of an alias. I have found that aliases were not defined as I thought they should be. (Data lost, not stored properly?) I need a way to view and edit aliases external to RE and Model Update.