Re: is it possible to see who dropped a DB link or would 9i do it on its own due to bug?

> Search on Metalink for notes how to find a drop of a databaselink. I know
> DDL is harder to find then DML. Not sure if it possible at all.

DDL is quite easy to find in 9i now. The DDL statement is logged into the archived redo logs so that LogMiner can pick them up. There is no SQL_UNDO for it though. But you can see if it was done!

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"