Extract DB Link and Materialized Views Definition

[Srikrishna Murthy Annam]

set long 999999999

SELECT DBMS_METADATA.GET_DDL('DB_LINK',dblnk.db_link,dblnk.owner) FROM dba_db_links dblnk where dblnk.db_link='TCOM_UP_TEM';

select dbms_metadata.get_ddl('MATERIALIZED_VIEW','INTRFC_SSC_APLCNT_DEC_PIT_DATA','SSC_ADMIN') txt from dual;