'result_cache relies on' invalidating function with synonym flip
Hi there. Wondering if anyone can help. Background: We maintain 2 schemas with identical tables. We point synonyms to the tables in one schema while we are loading tables in the other one with fresh data. When the tables are loaded, we flip the synonyms to the new data. We have never had a problem with any objects invalidating when we flip the synonyms - that is, until we started creating functions with 'result_cache relies on'. Any insights as to why the function becomes invalid when the view in the 'relies on' clause has it's synonym flipped? And what can be done to remedy this problem (short of removing the result_cache in the function). Any help would be appreciated - thanks! Paul.