DBA_EXTERNAL_TABLES

Description of the external tables accessible to the DBA

Columns
   ___________________________
 
   OWNER
      Owner of the external table
   TABLE_NAME
      Name of the external table
   TYPE_OWNER
      Owner of the implementation type for the external table access driver
   TYPE_NAME
      Name of the implementation type for the external table access driver
   DEFAULT_DIRECTORY_OWNER
      Owner of the default directory for the external table
   DEFAULT_DIRECTORY_NAME
      Name of the default directory for the external table
   REJECT_LIMIT
      Reject limit for the external table
   ACCESS_TYPE
      Type of access parameters for the external table (CLOB/BLOB)
   ACCESS_PARAMETERS
      Access parameters for the external table

Related:

DBA_EXTERNAL_LOCATIONS