alter public database link to private in oracle 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.
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.