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 execute the SHOW VARIABLES statement or query the SYS.TENANT_VIRTUAL_SESSION_VARIABLE view (Oracle mode) or the information_schema.SESSION_VARIABLES view (MySQL mode) to view the values of session system variables.

• Modify variables

  The sys tenant and all user tenants can directly modify the values of session system variables in their own tenants.

Attributes

Examples

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

obclient> SET ob_last_schema_version = 1749025079596944;