Deallocate a multi-tenant table from a database enabled for multi-tenancy.

Syntax

proutil dbname -C deallocate [owner.]table-name

          tenant [tenant-name | group group-name ]

Parameters

db-name

Specifies the database with the table to be deallocated.

[owner.]table-name

Specifies the name of the multi-tenant table to be deallocated. owner is required if the table owner is not PUB.

tenant tenant-name

Specifies the tenant whose table partition is to be deallocated. tenant-name cannot be a member of a group.

group group-name

Specifies the group whose table partition is to be deallocated.

Notes

• DEALLOCATE works both online and offline.
• DEALLOCATE only executes on multi-tenant tables in a multi-tenancy enabled database.
• Multiple instances of DEALLOCATE can run online at the same time, provided they are not attempting to deallocate the same table for the same tenant or group.
• The super-tenant can deallocate other tenant's or group's table instance.
• If DEALLOCATE detects any users (particularly no-lock readers) when the deallocation is executing, the utility waits for them to exit from the transition state printing the following messages:

  Waiting for user(s) to finish record operation. If you'd like to cancel this operation, press CTRL-C.