Note
This view is available starting with V4.4.0.
Purpose
The oceanbase.CDB_OB_EXTERNAL_RESOURCES view displays all uploaded resource files in the sys tenant.
| Column | Type | Nullable | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The ID of the tenant to which the resource belongs. |
| RESOURCE_ID | bigint(20) | NO | The ID of the resource. This is the unique identifier of the resource. |
| DATABASE_ID | bigint(20) | NO | The ID of the database to which the resource belongs. |
| NAME | varchar(256) | NO | The name of the resource. |
| TYPE | varchar | NO | The type of the resource. This field is used to distinguish between different types of resources, such as Java jar files and Python source code. The value of this field can be either 'JAVA_JAR' or '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
obclient > SELECT * FROM oceanbase.CDB_OB_EXTERNAL_RESOURCES;