Purpose
The oceanbase.ALL_OB_EXTERNAL_TABLE_FILES view displays the list of external files of external tables accessible to the current user.
Note
This view is introduced since OceanBase Database V4.2.0.
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. |