Note
This view is available starting with V4.2.0.
Purpose
This view displays the list of files in all external tables that the current user has access permissions to.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| TABLE_NAME | VARCHAR2(256) | YES | The name of the external table. |
| OWNER | VARCHAR2(128) | YES | The name of the database where the external table is located. |
| PARTITION_NAME | CHAR(2) | NO | The partition name of the external table. |
| FILE_URL | VARBINARY(16384) | NO | The URL of the external table file. |
| FILE_SIZE | NUMBER(38) | NO | The size of the file. |
Sample query
Query the list of files in all external tables that the current user has access permissions to.
obclient [SYS]> SELECT * FROM SYS.ALL_OB_EXTERNAL_TABLE_FILES;
The query result is as follows:
+------------+-------+----------------+------------------------------+-----------+
| TABLE_NAME | OWNER | PARTITION_NAME | FILE_URL | FILE_SIZE |
+------------+-------+----------------+------------------------------+-----------+
| EXT_T3 | SYS | P0 | xx.xx.xx.208:2882%data.csv | 29 |
+------------+-------+----------------+------------------------------+-----------+
1 row in set
References
Query the list of files in all external tables created by all tenants: CDB_OB_EXTERNAL_TABLE_FILES
Query the list of files in all external tables created by the current tenant: DBA_OB_EXTERNAL_TABLE_FILES
For more information about external tables and how to operate them, see Manage external files.