Drop the Cache Groups

Use the DROP CACHE GROUP statement to drop a cache group and its cache tables. On the Oracle database, the metadata objects used to manage the caching of the associated cached tables in the Oracle database are automatically removed.

Use the ttIsql utility to connect to the cache1 DSN as the instance administrator.

Grant the DROP ANY TABLE privilege to the TimesTen cache administration user so that this user can drop the underlying cache tables when dropping cache groups.

% ttIsql cache1
Command> GRANT DROP ANY TABLE TO cacheadmin;
Command> exit
Disconnecting...
Done.

Start the ttIsql utility and connect to the cache1 DSN as the cache administration user. Use ttIsql to drop the customer_orders AWT cache group.

% ttIsql "DSN=cache1;UID=cacheadmin;PwdWallet=/wallets/cacheadminwallet"
Command> DROP CACHE GROUP awt_customers;

The awt_customers cache group and its respective cache table sales.customers are dropped from the TimesTen database. Any metadata objects created for managing the caching operations for this cache group are removed in the Oracle database.

See Dropping a Cache Group in the Oracle TimesTen In-Memory Database Cache Guide.