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

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

    jnp1234

      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':

      DB_LINKUSERNAMEPASSWORDHOST
      XXXXXX(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=db-s001-scan.domain)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=xxx_yyy_t)))

       

      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