Purpose
The 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 | VARCHAR2(256) | YES | The name of the external table. |
| OWNER | VARCHAR2(128) | YES | The name of the database where the external table resides. |
| PARTITION_NAME | CHAR(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 | NUMBER(38) | NO | The size of the external file. |