Purpose
The oceanbase.DBA_OB_ZONES view displays the information about all zones.
Note
This view is introduced since OceanBase Database V4.0.0.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| ZONE | varchar(128) | NO | The name of the zone. |
| CREATE_TIME | timestamp(6) | NO | The time when the zone was created. |
| MODIFY_TIME | timestamp(6) | NO | The time when the zone was modified. |
| STATUS | varchar(4096) | NO | The status of the zone. Valid values: ACTIVE: The zone is active and provides services normally.INACTIVE: The zone is stopped. |
| IDC | varchar(4096) | NO | The IDC to which the zone belongs. |
| REGION | varchar(4096) | NO | The region where the zone belongs. |
| TYPE | varchar(4096) | NO | The type of the zone. Valid values: ReadWrite: read/write zoneEncryption: encrypted zone |