Convert Private DB link to PUBLIC

Oct 13, 2020 5:10AM

There are no issues with roles or privileges. I had database link as

--------------------------------------------------------

-- DDL for DB Link DMX

--------------------------------------------------------

CREATE DATABASE LINK "DMX"

CONNECT TO "DMX" IDENTIFIED BY VALUES ':1'

USING '(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = <hostname>)(PORT = 1521))

) (CONNECT_DATA =

(SERVICE_NAME = <instanceName>)))';

===================OPTION 1 ===========================

CREATE PUBLIC DATABASE LINK "DMX"

CONNECT TO "DMX" IDENTIFIED BY VALUES 'from user$'

USING '(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = rgt-pedb-spv01)(PORT = 1521))

) (CONNECT_DATA =

(SERVICE_NAME = FINDERP)))';

On 11.2.04 onwards Values is not supported

===============OPTION 2================================

update sys.LINK$ set owner#=1 where name='DMX';

Question?

is it safe to update the sys.LINK$ directly. what is the impact?

Database Administration (MOSC)