Database Administration (MOSC)

MOSC Banner

object name user_objects with object_type = 'TABLE' but in user_tables the table does not exists.

edited Aug 24, 2009 8:26AM in Database Administration (MOSC) 14 commentsAnswered ✓
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 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center