Note
This view is available starting with V4.4.0.
Purpose
The oceanbase.DBA_OB_EXTERNAL_RESOURCES view displays uploaded resource files.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| RESOURCE_ID | bigint(20) | NO | The ID of the resource, which uniquely identifies the resource. |
| DATABASE_ID | bigint(20) | NO | The ID of the database to which the resource belongs. |
| DATABASE_NAME | varchar(128) | NO | The name of the database to which the resource belongs. |
| NAME | varchar(256) | NO | The name of the resource. |
| TYPE | varchar(12) | NO | The type of the resource. Valid values: {'JAVA_JAR', 'PYTHON_PY'}. |
| CONTENT | longblob | NO | The binary content of the resource. |
| COMMENT | varchar(4096) | NO | The comment added when the resource was uploaded. |
Sample query
Execute the following SQL statement to query the uploaded resource files in the current tenant.
obclient > SELECT * FROM oceanbase.DBA_OB_EXTERNAL_RESOURCES;