Check tables, indexes, views, materialized views
637711Nov 13 2008 — edited Nov 15 2008I have to run an application, and before running the application, i have to make sure that the Database to which the application is connected to has all the required Tables, Indexes, Views, Materialized Views, Stored Procedures.
CAn this checking be done using some Stored Procedures or functions.. Is it possible to write a script for doing this kind of checking..
I know querying All_Objects, all_tables, all_Views..etc, will give me the tables, views, stored procedures stored in the DB.. But how can i use it to check if the existing Tables, Views, Stored Procedures are the ones that is required by the application..
Is it possible to write some script to do the checking... can anybody give me some idea on doing it, if possible..