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 of the external table |
|
|
|
Name of the external table |
|
|
Owner of the implementation type for the external table access driver |
|
|
|
|
Name of the implementation type for the external table access driver |
|
|
Owner of the default directory for the external table |
|
|
|
|
Name of the default directory for the external table |
|
|
Reject limit for the external table, or |
|
|
|
Type of access parameters for the external table:
|
|
|
|
Access parameters for the external table |
|
|
|
Property of the external table:
|
See Also: