使用dbms_metadata获取dblink

wangxu

使用dbms_metadata获取dblink

在expdp按shemas方式导出用户，进行编译发现部分报失效，找到原因是因为dblink缺失导致，通过下面语句获取并在目标库创建，重新编译即可：

col owner for a20
col db_link for a20
col username for a20
select OWNER,DB_LINK,USERNAME from dba_db_links;



set long 1000000
SET PAGESIZE 3000
set lines 200
SET HEADING OFF
SET VERIFY OFF
SET FEEDBACK OFF
set echo on
set timing off
set wrap On
SET LONGCHUNKSIZE 400
SELECT dbms_metadata .get_ddl('DB_LINK',DB_LINK,OWNER) from dba_db_links;