How to find a list of active views in an Oracle schema? The dba_objects, all_views and other sys tables included the dropped views as well, but we would like to get active list.
How to find a list of active views in an Oracle schema?I don't really know what you mean by "active"
The dba_objects, all_views and other sys tables included the dropped views as well
I don't what you mean by this either. Dropped objects don't appear in those views ?
SQL> create view my_view as select * from dual;
View created.
SQL> select count(*) from dba_objects where object_name = 'MY_VIEW';
COUNT(*)
----------
1
SQL> drop view my_view;
View dropped.
SQL> select count(*) from dba_objects where object_name = 'MY_VIEW';
COUNT(*)
----------
0
Perhaps take a look at v$segment_statistics. Maybe that is what you are after ?