Re: views/sequences

select object_name, object_type, status from all_objects where owner = <owner> and object_type in ('SEQUENCE', 'TRIGGER');

select view_name from all_views ;

--
Posted via http://dbforums.com