Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Private DB LINK drop using ALTER SESSION SET CURRENT_SCHEMA

user92272Nov 18 2008 — edited Nov 18 2008
I am not able to drop a private db link using
ALTER SESSION SET CURRENT_SCHEMA =owner;
I logged as sysdba

However, I am able to drop when I login directly as the owner of the db link. Does this mean, I can not drop a db link using ALTER SESSION SET CURRENT_SCHEMA

Thanks,
Siva
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 16 2008
Added on Nov 18 2008
#db, #general-database-discussions, #link
1 comment
794 views