Database Administration (MOSC)

MOSC Banner

drop table with a LOB column and now have funky info in DBA_LOBS

edited Oct 27, 2009 3:32AM in Database Administration (MOSC) 2 commentsAnswered
 Before i dropped this table, i had information in DBA_TABLES, DBA_LOBS, DBA_OBJECTS, etc, etc.

I wanted to drop a table that had a LOB in it from the appliation that's on our 10.2.0.4 database. I dropped the table, but now there's some very strange information that's taken the place of the row that was in DBA_LOBS for the LOB on that table.

TABLE_NAME                                                              COLUMN_NAME

BIN$dtzYUlZNaTfgRAAeC4OSwg==$0                     AORJPST_REQMNT

The table was called AORJPST (or something like that), now it has a row in DBA_LOBS with that table_name, above...

Anybody know what that is, or how to get rid of it?  did i do something wrong dropping the table?  it was a simple DROP TABLE <table_name> command i issued.

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