>>>Anyone got a quick way to remove table references in a DBC after the table has been deleted? Or do I need to USE the DBC and do it manually?
>>>TIA
>>
>>You could use REMOVE TABLE command. This way all references will be cleared.
>
>Edward,
>the problem is that if the table does not exist then remove table generates an error and does not remove the reference. Same thing with drop table.
OPEN your database exclusively.
Then do VALIDATE DATABASE RECOVER
it will give you the option to remove the missing table.