Note
This view is introduced since OceanBase Database V4.2.0.
Purpose
This view displays the list of external files of external tables accessible to the current user.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TABLE_NAME | varchar(256) | NO | The name of the external table. |
| TABLE_SCHEMA | varchar(128) | NO | The name of the database where the external table resides. |
| PARTITION_NAME | varchar(2) | NO | The partition name of the external table. |
| FILE_URL | varbinary(16384) | NO | The access URL of external files of the external table. |
| FILE_SIZE | bigint(20) | NO | The size of the external file, in bytes. |
Sample query
Query the list of files for the external tables that the current user has access to.
obclient [oceanbase]> SELECT * FROM oceanbase.ALL_OB_EXTERNAL_TABLE_FILES;
The query result is as follows:
+-------------------------------+------------------+----------------+-------------------------------+-----------+
| TABLE_NAME | TABLE_SCHEMA | PARTITION_NAME | FILE_URL | FILE_SIZE |
+-------------------------------+------------------+----------------+-------------------------------+-----------+
| __all_external_alert_log_info | sys_external_tbs | P0 | 172.xx.xxx.xxx:2882%alert.log | 6473 |
+-------------------------------+------------------+----------------+-------------------------------+-----------+
1 row in set
References
Query the file list of all external tables created by all tenants: CDB_OB_EXTERNAL_TABLE_FILES
Query the file list of all external tables created by the current tenant: DBA_OB_EXTERNAL_TABLE_FILES
For more information about external tables, see Manage external files.