--show invalid views for a schema select object_name from user_objects where object_type = 'VIEW' and status = 'INVALID' /