Another interesting issue

Posted by Linda on Jan 16, 2017; 12:43pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Another-interesting-issue-tp1918.html

Hi Erman!
Again me , seeing this or do I have  a bug now :)
create materialized  view XX_MV
gives ORA-955 name is already used by an existing object
SELECT * FROM dba_OBJECTS WHERE OBJECT_NAME LIKE '%XX_MV%'  ->  doesn’t show any object XX_MV.
 
dba_OBJECTS using    select from sys."_CURRENT_EDITION_OBJ" (joined with user).

select * from sys."_CURRENT_EDITION_OBJ" where NAME LIKE 'XX_MV'
Here I get XX_MV with type# 10 where 10 means object not exists (based on comment in view dba_OBJECTS).
The adop phase is all completed.
resycle bin is oFf in database. Still run purged recycle_bin.. Still the same

Any idea how I can cleanup this object type 10 ?
Thanks for the hint!
Br,Linda