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.
- 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 |
No comments:
Post a Comment