Drop object in RAC: ORA-04043: object Math does not exist
Hello,
We have Oracle RAC 12.1.0.2 SE2 on Linux x64 which consists of 2 nodes and uses ASM for storing datafiles.
This RAC is used by developers and there we have multiple schemas (10+) with the same objects inside(one schema per developer).
In particular. we have a Java object with name Math there (more than 10 copies of it in the whole DB).
Schemas created and cleaned often by using the tool, called flyway
Normal usage of the tool is like this
./flyway clean migrate
The problem is that when I'm trying to clean schema (It drops all objects in the schema) while connected to SCAN address of the RAC, I'm frequently getting error: