1

I have a database link in my database which is created as public as below.

CREATE PUBLIC DATABASE LINK dblink_name CONNECT TO usernane USING 'tag';

I have a requirement to convert it to a PRIVATE database link. Is there any way to ALTER it without recreating it?

Many thanks.

Improve this question
1
  • 1
    A note about private links - you cannot create a private database link in a schema besides your own, and only the owner of a private database link can drop it (not even SYS can drop private database links created/owned by other schemas). Some Oracle docs reference here.
    – ansible
    Commented Oct 6, 2016 at 18:28

1 Answer 1

Reset to default
2

No. You'll need to create a new private database link. Public database links (and synonyms) are owned by a different user than private database links (and synonyms) and you can't alter an object to change the owner.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.