Database Administration (MOSC)

MOSC Banner

dbms_metadata gives invalid DDL for db_links under 11.2.0.4

edited May 3, 2019 4:52AM in Database Administration (MOSC) 12 commentsAnswered

We use dbms_metadata.get_ddl to capture database links prior to refreshing a development database.

On databases that have been patched to 11.2.0.4, the procedure returns an invalid value for the password hash.

It literally returns ':1'

Here is an example of what it returns:



db_link_sql := dbms_metadata.get_ddl(object_type => 'DB_LINK', name => 'MYLINK.WORLD', schema=> 'MYSCHEMA');


Result:


CREATE DATABASE LINK "MYLINK.WORLD"

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

  USING ''DB''');

Has anyone seen this before?  Is it a bug, or do I need to do something different in 11.2.0.4?

Thanks

-Greg

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center