I have created a feature class in an Oracle 11g database connection with ArcCatalog 10.2 (without ArcSDE) and I can see the table in the database with Sql Developer without problems. But, if I drop this table with a sql statement in Sql Developer and then refresh the database connection in ArcCatalog, the feature class does not disappear (even if I create a new feature class with the same name, I have an Invalid name error because the name already exists).
I have tried the same scenario with a view, and there is no problem, ArcCatalog updates.
I could remove the feature class in ArcCatalog, but I need to use a stored procedure in the database to drop the table and after that refresh ArcCatalog.
Any ideas why ArcCatalog does not refresh?