oceanbase.DBA_OB_TABLE_LOCATIONS|V5.0.1|OceanBase Database|docs|OceanBase Documentations

Column	Type	Nullable	Description
DATABASE_NAME	varchar(128)	NO	The name of the database.
TABLE_NAME	varchar(256)	NO	The name of the table.
TABLE_ID	bigint(20)	NO	The ID of the table.
TABLE_TYPE	varchar(13)	NO	The type of the table. Valid values: USER TABLE: user table SYSTEM TABLE: system table, which is automatically created by the system INDEX: index table LOB AUX TABLE: LOB auxiliary table, which is automatically created by the system to assist in implementing LOB columns
PARTITION_NAME	varchar(64)	NO	The name of the partition. For non-partitioned tables, this column is NULL.
SUBPARTITION_NAME	varchar(64)	NO	The name of the subpartition. If no subpartition exists, this column is NULL.
INDEX_NAME	varchar(256)	NO	The name of the index table. If the table is not an index table, this column is NULL.
DATA_TABLE_ID	bigint(20)	NO	The ID of the main table to which the index table or LOB auxiliary table belongs. If the table is not an index table or LOB auxiliary table, this column is NULL.
TABLET_ID	bigint(20)	NO	The ID of the tablet.
LS_ID	bigint(20)	NO	The ID of the log stream to which the object belongs.
ZONE	varchar(128)	NO	The zone where the replica is located.
SVR_IP	varchar(46)	NO	The IP address of the server where the replica is located.
SVR_PORT	bigint(20)	NO	The port number of the server where the replica is located.
ROLE	varchar(8)	NO	The role of the replica.
REPLICA_TYPE	varchar(18)	NO	The type of the log stream replica. Valid values: `FULL`: full-featured replica `READONLY`: read-only replica `COLUMNSTORE`: columnstore replica
DUPLICATE_SCOPE	varchar(7)	NO	The value indicates whether the table is a replicated table. Valid values: `CLUSTER`: replicated table `NONE`: regular table Note This column is available starting with V4.2.0.
DUPLICATE_READ_CONSISTENCY	varchar(6)	NO	The value indicates the read consistency constraint of the standby replica of a replicated table. Valid values: `NONE`: indicates that the table is not a replicated table. This value is meaningless for non-replicated tables. `STRONG`: indicates that the standby replica of a replicated table supports strong-consistency reads. Note This column is available starting with V4.3.4.
OBJECT_ID	bigint(20)	NO	The ID of the partition. Note This column is available starting with V4.2.0.
TABLEGROUP_NAME	varchar(128)	NO	The name of the table group to which the table belongs. Note This column is available starting with V4.2.0.
TABLEGROUP_ID	bigint(20)	NO	The ID of the table group to which the table belongs. Note This column is available starting with V4.2.0.
SHARDING	varchar(20)	NO	The sharding attribute (balance mode) of the table group to which the table belongs. Note This column is available starting with V4.2.0.
SCOPE	varchar(20)	NO	The `SCOPE` attribute of the table group. Valid values: `SERVER`: all partition groups have their leaders on the same node. `ZONE`: all partition groups have their leaders within the same zone but are distributed across different nodes in the zone. `CLUSTER`: all partition groups have their leaders distributed across different nodes in the cluster. Note For OceanBase Database V5.x, this column is available starting with V5.0.1.
INDEX_TYPE	varchar(6)	NO	The value indicates the `GLOBAL`/`LOCAL` attribute of the index of an index table. Valid values: `NULL`: indicates that the table is not an index table. `GLOBAL`: indicates a global index. Valid values: `INDEX_TYPE_NORMAL_GLOBAL`, `INDEX_TYPE_UNIQUE_GLOBAL`, and `INDEX_TYPE_SPATIAL_GLOBAL`. `LOCAL`: indicates a local index. Valid values: `INDEX_TYPE_NORMAL_LOCAL`, `INDEX_TYPE_UNIQUE_LOCAL`, `INDEX_TYPE_PRIMARY`, `INDEX_TYPE_DOMAIN_CTXCAT`, `INDEX_TYPE_NORMAL_GLOBAL_LOCAL_STORAGE`, `INDEX_TYPE_UNIQUE_GLOBAL_LOCAL_STORAGE`, `INDEX_TYPE_SPATIAL_LOCAL`, and `INDEX_TYPE_SPATIAL_GLOBAL_LOCAL_STORAGE`. Note For OceanBase Database V4.4.x, this column is available starting with V4.4.1. For OceanBase Database V4.2.5, this column is available starting with V4.2.5 BP2.

DATABASE_NAME

varchar(128)

NO

The name of the database.

TABLE_NAME

varchar(256)

NO

The name of the table.

TABLE_ID

bigint(20)

NO

The ID of the table.

TABLE_TYPE

varchar(13)

NO

The type of the table. Valid values:

USER TABLE: user table
SYSTEM TABLE: system table, which is automatically created by the system
INDEX: index table
LOB AUX TABLE: LOB auxiliary table, which is automatically created by the system to assist in implementing LOB columns

PARTITION_NAME

varchar(64)

NO

The name of the partition. For non-partitioned tables, this column is NULL.

SUBPARTITION_NAME

varchar(64)

NO

The name of the subpartition. If no subpartition exists, this column is NULL.

INDEX_NAME

varchar(256)

NO

The name of the index table. If the table is not an index table, this column is NULL.

DATA_TABLE_ID

bigint(20)

NO

The ID of the main table to which the index table or LOB auxiliary table belongs. If the table is not an index table or LOB auxiliary table, this column is NULL.

TABLET_ID

bigint(20)

NO

The ID of the tablet.

LS_ID

bigint(20)

NO

The ID of the log stream to which the object belongs.

ZONE

varchar(128)

NO

The zone where the replica is located.

SVR_IP

varchar(46)

NO

The IP address of the server where the replica is located.

SVR_PORT

bigint(20)

NO

The port number of the server where the replica is located.

ROLE

varchar(8)

NO

The role of the replica.

REPLICA_TYPE

varchar(18)

NO

The type of the log stream replica. Valid values:

FULL: full-featured replica
READONLY: read-only replica
COLUMNSTORE: columnstore replica

DUPLICATE_SCOPE

varchar(7)

NO

The value indicates whether the table is a replicated table. Valid values:

CLUSTER: replicated table
NONE: regular table

Note

This column is available starting with V4.2.0.

DUPLICATE_READ_CONSISTENCY

varchar(6)

NO

The value indicates the read consistency constraint of the standby replica of a replicated table. Valid values:

NONE: indicates that the table is not a replicated table. This value is meaningless for non-replicated tables.
STRONG: indicates that the standby replica of a replicated table supports strong-consistency reads.

Note

This column is available starting with V4.3.4.

OBJECT_ID

bigint(20)

NO

The ID of the partition.

Note

This column is available starting with V4.2.0.

TABLEGROUP_NAME

varchar(128)

NO

The name of the table group to which the table belongs.

Note

This column is available starting with V4.2.0.

TABLEGROUP_ID

bigint(20)

NO

The ID of the table group to which the table belongs.

Note

This column is available starting with V4.2.0.

SHARDING

varchar(20)

NO

The sharding attribute (balance mode) of the table group to which the table belongs.

Note

This column is available starting with V4.2.0.

SCOPE

varchar(20)

NO

The SCOPE attribute of the table group. Valid values:

SERVER: all partition groups have their leaders on the same node.
ZONE: all partition groups have their leaders within the same zone but are distributed across different nodes in the zone.
CLUSTER: all partition groups have their leaders distributed across different nodes in the cluster.

Note

For OceanBase Database V5.x, this column is available starting with V5.0.1.

INDEX_TYPE

varchar(6)

NO

The value indicates the GLOBAL/LOCAL attribute of the index of an index table. Valid values:

NULL: indicates that the table is not an index table.
GLOBAL: indicates a global index. Valid values: INDEX_TYPE_NORMAL_GLOBAL, INDEX_TYPE_UNIQUE_GLOBAL, and INDEX_TYPE_SPATIAL_GLOBAL.
LOCAL: indicates a local index. Valid values: INDEX_TYPE_NORMAL_LOCAL, INDEX_TYPE_UNIQUE_LOCAL, INDEX_TYPE_PRIMARY, INDEX_TYPE_DOMAIN_CTXCAT, INDEX_TYPE_NORMAL_GLOBAL_LOCAL_STORAGE, INDEX_TYPE_UNIQUE_GLOBAL_LOCAL_STORAGE, INDEX_TYPE_SPATIAL_LOCAL, and INDEX_TYPE_SPATIAL_GLOBAL_LOCAL_STORAGE.

Note

For OceanBase Database V4.4.x, this column is available starting with V4.4.1.
For OceanBase Database V4.2.5, this column is available starting with V4.2.5 BP2.

oceanbase.DBA_OB_TABLE_LOCATIONS

Note

Purpose

Columns

Note

Note

Note

Note

Note

Note

Note

Note