Rename a tenant

After you create a sys tenant, you can rename a regular tenant.

At present, OceanBase Database allows you to rename only regular tenants.

Considerations

If you rename a tenant by using the command-line interface (ALTER TENANT) , the tenant appears unavailable in OCP. If you need to manage the tenant in OCP, perform the renaming operation in OCP. For more information about how to rename a tenant in OCP, see Common questions about OceanBase tenants.

Procedure

1. Log in to the sys tenant of the cluster as the root user.

2. Rename the regular tenant.

   The following code shows the syntax for the ALTER TENANT statement:

   ALTER TENANT old_tenant_name RENAME GLOBAL_NAME TO new_tenant_name;
   

   For example, rename the tenant1 tenant to tenant2:

   obclient> ALTER TENANT tenant1 RENAME GLOBAL_NAME TO tenant2;
   

References

For more information about the ALTER TENANT statement, see ALTER TENANT.