I see one strange issue, sys not able to drop database link from different owner.. i wonder if am misssing something or is it a problem with oracle?
Code:CST7QST_ITF> show user
USER is "SYS"
CST7QST_ITF> alter session set current_schema = FIMT_AUDIT_TST;
Session altered.
Elapsed: 00:00:01.11
CST7QST_ITF> drop database link IMQ09ITF;
drop database link IMQ09ITF
*
ERROR at line 1:
ORA-01031: insufficient privileges
Elapsed: 00:00:01.41
CST7QST_ITF>
Rgds
Abhay.