Originally posted by tycho
JModic,

Ever tried deleting from sys.link$

Tycho
As a matter of fact, I did (among other database "hacking" games), however I can't see how this is relevant here. And BTW, I would not be too comfortable with publicly suggesting to mess up with database dictionary on an open forum like this one - some inexperienced user might even take it seriously and try something simmilar on the production system.....

The isue is not if something is possible at all (if it would not be, how would oracle then do it during "DROP USER" action), the isue is if you can do it with supported actions, like legal DDL statements and PL/SQL APIs. With this in mind I say again: It is not possible to create bullet-proof script to drop all the objects from user schema if you can not connect as the schema owner during the script execution.