Thursday, February 18, 2010

Oracle PL/SQL queries 3 - How to see invalid view or other objects in the database

To find invalid view, table, java class, procedure, etc in a table, use 'select * from all_objects where object_type = 'invalid';

No comments:

Post a Comment

LinkWithin

Related Posts with Thumbnails