Similar to multi-tenant tables, a super tenant can access a multi-tenant sequence owned by a particular tenant using the following functions:

  • CURRENT-VALUE and DYNAMIC-CURRENT-VALUE function — Provides an option to return the current value of the multi-tenant sequence for the specified tenant.
  • NEXT-VALUE and DYNAMIC-NEXT-VALUE function — Provides an option to return the next value of the multi-tenant sequence for the specified tenant.

However, note that if you configure, or ever intend to configure, tables with tenant groups or shared tables in a multi-tenant database, certain uses of a multi-tenant sequences can have unintended consequences, both for regular and super-tenant users. The following section describes these potential issues.