DROP RESOURCE POOL

Syntax

SQL

DROP RESOURCE POOL pool_name

Remarks

pool_name: The name of a resource pool.
DROP POOL privileges are required for dropping a resource pool.
Refer to the Permission Matrix for the required permission.

Warning

Open connections to a database are assigned to a specific resource pool (or default_pool if no other pool is selected). Before dropping a resource pool, you should set resource_pool to another value; otherwise only DDL commands can be run from those connections until a new resource_pool value has been set.

You cannot drop the built-in resource pools. You also cannot drop a pool that is the default startup pool for a user.

Example

This example assumes that the resource pool test_pool exists and that you want to drop it.

Before dropping test_pool, set the current resource pool to a value other than test_pool:

SQL

SET resource_pool = default_pool;

Then drop the test_pool:

SQL

DROP RESOURCE POOL test_pool;