關於database link的物件型別

SQL> col OBJECT_NAME format a30
SQL> col OBJECT_TYPE format a20
SQL> select object_name,OBJECT_TYPE
  2  FROM user_objects
  3  where object_name like 'CIQUS%';


OBJECT_NAME                    OBJECT_TYPE
------------------------------ --------------------
CIQUSR_SYNC.168.3.9            DATABASE LINK
CIQUSR_SYNC.US.ORACLE.COM      DATABASE LINK


SQL> select DBMS_METADATA.GET_DDL ('DATABASE LINK','CIQUSR_SYNC.US.ORACLE.COM')
  2  from dual;
ERROR:
ORA-31600: invalid input value DATABASE LINK for parameter OBJECT_TYPE in
function GET_DDL
ORA-06512: at "SYS.DBMS_METADATA", line 3773
ORA-06512: at "SYS.DBMS_METADATA", line 3828
ORA-06512: at "SYS.DBMS_METADATA", line 5678
ORA-06512: at line 1


no rows selected


SQL> select DBMS_METADATA.GET_DDL ('DB_LINK','CIQUSR_SYNC.US.ORACLE.COM')
  2  FROM DUAL;


DBMS_METADATA.GET_DDL('DB_LINK','CIQUSR_SYNC.US.ORACLE.COM')
--------------------------------------------------------------------------------


  CREATE DATABASE LINK "CIQUSR_SYNC.US.ORACLE.COM"
   CONNECT TO "ITOWM" IDENTI




SQL> SELECT *
  2  from user_db_links;


DB_LINK
--------------------------------------------------------------------------------
USERNAME                       PASSWORD
------------------------------ ------------------------------
HOST
--------------------------------------------------------------------------------
CREATED
------------
CIQUSR_SYNC.168.3.9
ITOWM
oral_sz
06-SEP-17




DB_LINK
--------------------------------------------------------------------------------
USERNAME                       PASSWORD
------------------------------ ------------------------------
HOST
--------------------------------------------------------------------------------
CREATED
------------
CIQUSR_SYNC.US.ORACLE.COM
ITOWM
oral_sz
06-SEP-17