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.

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
    Oct 6 '16 at 18:28
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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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