Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Check tables, indexes, views, materialized views

637711Nov 13 2008 — edited Nov 15 2008
I 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..
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 13 2008
Added on Nov 13 2008
18 comments
831 views