ob_last_schema_version

Description

ob_last_schema_version specifies the latest schema version used in the current session.

When a Proxy connection is mapped to multiple servers, you must use this system variable to synchronize schemas. Therefore, this variable takes effect only at the session level.

Privilege requirements

• Query variables

  The sys tenant and all user tenants can use the SHOW VARIABLES statement or the SYS.TENANT_VIRTUAL_SESSION_VARIABLE view (Oracle mode) and the information_schema.SESSION_VARIABLES view (MySQL mode) to query the value of a session system variable.

• Modify variables

  The sys tenant and all user tenants can directly modify the value of a session system variable in their own tenant.

Attributes

Examples

Set the latest schema version used in the current session to 1749025079596944.

obclient> SET ob_last_schema_version = 1749025079596944;