Oracle is not behaving strange, as per Oracle documentation this is what's supposed to happen.
Since there is not such a thing as DROP ANY DBLINK system privilege, private DBLINKs can be dropped only by the rightfull owner.
Printable View
Oracle is not behaving strange, as per Oracle documentation this is what's supposed to happen.
Since there is not such a thing as DROP ANY DBLINK system privilege, private DBLINKs can be dropped only by the rightfull owner.
well yea.. but ..
Well just see what oracle does when you do drop user cascade.. it first tries to drop all objects and then actually remove the entry from user$.. now any user with DBA previlege can do this.. now my question is why should a user with DBA previlege not be able to do this operation?
Rgds
Abhay.
isnt it embrassing thing that sys gets "ORA-01031" while some operation?
Since this is a documented feature you should ask the question to Oracle, I'm pretty sure Angelo and crew will be delighted to deal with it.Quote:
Originally Posted by abhaysk