views:

86

answers:

0

Hey, I have TimesTen local store which open cache connect to an Oracle data store. Sometimes I need to drop the whole Oracle schema (Entities changes etc..), so I simply drop every table, and recreate it. The problem I'm facing at this stage is by getting inifite XLA messages (in the TimesTen side) for every entity in every table (I get update, add and delete events).

To solve the problem I have to truncate the inner Oracle tables.

I understand that dropping cached table without doing something with the cachegroup is problematic.

What is the right way to drop an entire schema? Is truncating the TimesTen inner tables' a good solution?

Thanks,

Udi