object name user_objects with object_type = 'TABLE' but in user_tables the table does not exists.
I am not sure how this has happened but below shows the object I have in user_objects of object_type = 'TABLE';
"OBJECT_NAME" = BIN$BCt8yl57S5G0tJ754zF9NQ==$0
"OBJECT_ID" = 73472
SELECT * FROM user_tables * FROM user_tables where table_name = 'BIN$BCt8yl57S5G0tJ754zF9NQ==$0'; 0 rows returned. table_name = 'BIN$BCt8yl57S5G0tJ754zF9NQ==$0'; 0 rows returned. 0 rows returned.
1. How can I drop this object of object_type table when its not really a table?
2. Any idea how this type of bad data could have happened?
thanks
Tim
0