dbms_metadata.get_ddl No Longer Returns Password For Database Link (Doc ID 1684122.1)

Last updated on NOVEMBER 10, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

 In 11.2.0.4 and 12c, DBMS_METADATA.GET_DDL no longer retrieves the encrypted password.


In 11.2.0.4

SELECT DBMS_METADATA.GET_DDL('DB_LINK',DB_LINK,OWNER) from dba_db_links;
DBMS_METADATA.GET_DDL('DB_LINK',DB_LINK,OWNER)
--------------------------------------------------------------------------------

  CREATE PUBLIC DATABASE LINK "PROD.WORLD"
  CONNECT TO "TEST_USER" IDENTIFIED BY VALUES ':1' 
  USING 'TESTDB'

In 11.2.0.3


SELECT DBMS_METADATA.GET_DDL('DB_LINK',DB_LINK,OWNER) from dba_db_links;

DBMS_METADATA.GET_DDL('DB_LINK',DB_LINK,OWNER)
--------------------------------------------------------------------------------

  CREATE PUBLIC DATABASE LINK "PROD.WORLD"
  CONNECT TO "TEST_USER" IDENTIFIED BY VALUES '058956F705CC61442C51ABGHB609AE2DB12089624251CED53CC'  USING 'TESTDB'

So in 11.2.0.4, the extracted DDL can no longer be used to re-create the database objects containing password.
 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms