Thursday, July 30, 2009

DBA_EXTERNAL_TABLES

DBA_EXTERNAL_TABLES describes all external tables in the database. Its columns are the same as those in ALL_EXTERNAL_TABLES.

Related Views

  • ALL_EXTERNAL_TABLES describes the external tables accessible to the current user.
  • 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

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

Oracle data dictionary views

Oracle dynamic performance views

Last updated: July 30, 2009

DBA_EXTERNAL_LOCATIONS

DBA_EXTERNAL_LOCATIONS describes the locations (data sources) of all external tables in the database. Its columns are the same as those in ALL_EXTERNAL_LOCATIONS.

Related Views

  • ALL_EXTERNAL_LOCATIONS describes the locations (data sources) of the external tables accessible to the current user.
  • USER_EXTERNAL_LOCATIONS describes the locations (data sources) of 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 location

TABLE_NAME

VARCHAR2(30)

NOT NULL

Name of the corresponding external table

LOCATION

VARCHAR2(4000)

External table location clause

DIRECTORY_OWNER

CHAR(3)

Owner of the directory containing the external table location

DIRECTORY_NAME

VARCHAR2(30)

Name of the directory containing the external table location

Oracle data dictionary views

Oracle dynamic performance views

Last updated: July 30, 2009