ODA tool has been written to analyse Oracle database object dependencies between database objects such as procedures, tables, views etc. The tool can also be used to analyse object dependencies between objects in Forms source code and block properties and also the Oracle database.
ODA will give you the answer to questions about application dependencies:
- What Oracle database objects will be mentioned with alter the table/procedure/package?
- What DML operations are carried out above the table(select/update/delete/insert)? From this it is possible to draw a conclusion what privileges to give the user;
- While upgrading application in other environment (9i/10g/Java) can be planned that varies;
- Context of usage object display
- Object dependencies tree
- Detail object dependency search in parent object
- Globals and Parameters in forms
- Application objects relationships
- Forms statistics
