1 Reply Latest reply on Feb 4, 2019 2:06 PM by thatJeffSmith-Oracle

    Database links - shows <Generation of DDL failed>, not ddl


      Database link in connection browser:


      Opening XXX show information as expected in the details view.

      The SQL view only shows:

      --Generation of DDL failed



      select * from user_db_links where db_link='XXX':



      as does select DBMS_METADATA.get_ddl('DB_LINK','XXX','<Owner>') FROM dual;


      Seems to restricted links where host is defined with a connect string and not a (tns) name.



      SQL Developer 18.4