DROP CACHE GROUP

The DROP CACHE GROUP statement drops the table associated with the cache group, and removes the cache group definition from the CACHE_GROUP system table.

Required privilege

No privilege is required for the cache group owner or DROP ANY CACHE GROUP if not the cache group owner and

DROP ANY TABLE if at least one table in the cache group is not owned by the current user.

SQL syntax

DROP CACHE GROUP [Owner.]GroupName

Parameters

The DROP CACHE GROUP statement has the parameter:

Description

• If you attempt to delete a cache group table that is in use, TimesTen returns an error.

• ASYNCHRONOUS WRITETHROUGH cache groups cannot be dropped while the replication agent is running.

• Automatically installed Oracle objects for read-only cache groups and cache groups with the AUTOREFRESH attribute are uninstalled by the cache agent. If the cache agent is not running during the DROP CACHE GROUP operation, the Oracle objects are uninstalled on the next startup of the cache agent.

• If you issue a DROP CACHE GROUP statement, and there is an autorefresh operation currently running, then:

  • If LockWait interval is 0, the DROP CACHE GROUP statement fails with a lock timeout error.

  • If LockWait interval is non-zero, then the current autorefresh transaction is preempted (rolled back), and the DROP statement continues. This affects all cache groups with the same autorefresh interval.

Examples

DROP CACHE GROUP westerncustomers;

See also

ALTER CACHE GROUP
CREATE CACHE GROUP