Re: Possible table corruption?

Try

ANALYZE TABLE schema.tablename VALIDATE STRUCTURE;

Also try exporting the table. These should reveal any corruption in the table.

You might get rid of the table by exporting the database, dropping the non-SYS objects and importing everything explicitly except for the bad table.

However, inability to drop the table suggests that the data dictionary is corrupted. I wouldn't care to tackle repairing that without Oracle Support.

Paul de Anguera | "You can't write a chord ugly enough to say
Reply to:       | what you want to say sometimes, so you have to
deanguer@       | rely on a giraffe filled with whipped cream."
quidnunc.net    | - Frank Zappa