Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E10820-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

ALL_EXTERNAL_TABLES

ALL_EXTERNAL_TABLES describes the external tables accessible to the current user.

Related Views

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
DEFAULT_DIRECTORY_NAME VARCHAR2(30) NOT NULL Name of the default directory for the external table
REJECT_LIMIT VARCHAR2(40)   Reject limit for the external table, or UNLIMITED
ACCESS_TYPE VARCHAR2(7)   Type of access parameters for the external table:
  • BLOB

  • CLOB

ACCESS_PARAMETERS CLOB   Access parameters for the external table
PROPERTY VARCHAR2(10)   Property of the external table:
  • REFERENCED - Referenced columns

  • ALL - All columns