DROP CACHE GROUP

This statement is supported in TimesTen Scaleout.

In TimesTen Classic:

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.

If not the cache group owner, DROP ANY CACHE GROUP and

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

Usage with TimesTen Scaleout

This statement is not supported with TimesTen Scaleout.

SQL syntax

DROP CACHE GROUP [Owner.]CacheGroupName

Parameters

Parameter Description

[Owner.]CacheGroupName

Name of the cache group to be deleted.

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 Database 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 Database objects are uninstalled on the next startup of the cache agent.

  • You cannot execute the DROP CACHE GROUP statement when performed under the serializable isolation level. An error message is returned when attempted.

  • 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 nonzero, 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