title: How to get the list of external tables in oracle schema 11g
body: <p>I want to get the list of only external tables in oracle.
  i tried to get the list using Select * from tab . But it return list of all the table including actual and external . But i only want list of external tables</p>