SQL> set long 10000
SQL> select text from dba_views where view_name='STS_HOST_HBA' and owner=&owner;
SQL> select table_name, constraint_name
from dba_constraints
where table_name in ('tablename1', 'tablename2', .....) -- tables in the view.
and owner=&owner
and constraint_type='P'