Object Search does not show triggers in search result using Oracle 10g. Triggers can be viewed via Schema Browser. However, searching for specific text by Object Search does not show these triggers in search results. Connected to Oracle 10g client and server.
When searching for text in object source code via Object Search, Toad queries DBA_SOURCE view, which stores source code of all object types in database. Triggers created in Oracle 7.x were not compiled, and hence, were not included in DBA_SOURCE. Triggers only existed in DBA_TRIGGERS view. Upgrade to higher version of Oracle will still not have triggers included in DBA_SOURCE.
If triggers were originally created in version 7.x of Oracle, they have to be recreated in the new version to be added to DBA_SOURCE view, and hence, included in the search.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy