ALL_EXTERNAL_TABLES

ALL_EXTERNAL_TABLES describes the external tables accessible to the current user.

Related Views

• DBA_EXTERNAL_TABLES describes all external tables in the database.
• USER_EXTERNAL_TABLES describes the external tables owned by the current user. This view does not display the OWNER column.

  Column	Datatype	NULL	Description
  OWNER	VARCHAR2(30)	NOT NULL	Owner of the external table
  TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the external table
  TYPE_OWNER	CHAR(3)		Owner of the implementation type for the external table access driver
  TYPE_NAME	VARCHAR2(30)	NOT NULL	Name of the implementation type for the external table access driver
  DEFAULT_DIRECTORY_OWNER	CHAR(3)		Owner of the default directory for the external table (can be NULL)
  DEFAULT_DIRECTORY_NAME	VARCHAR2(30)	NOT NULL	Name of the default directory for the external table (can be NULL)
  REJECT_LIMIT	NUMBER		Reject limit for the external table (default is 0)
  ACCESS_TYPE	VARCHAR2(7)		Type of access parameters for the external table (CLOB/BLOB)
  ACCESS_PARAMETERS	VARCHAR2(4000)		Access parameters for the external table

  See Also: "DBA_EXTERNAL_TABLES" "USER_EXTERNAL_TABLES"