Oracle Database Discussions

Hi,

Os : Red hat5.4
Db:10.2

We tried to get the ddl of db link in the database using dbms_metadata.get_ddl.
But getting a error.

1* select OWNER,db_link from dba_db_links
P07-SQL> /

OWNER DB_LINK
------------------------------ --------------
IA SPX


select DBMS_METADATA.GET_DDL('DB_LINK','SPX','IA') from dual;
ERROR:
ORA-31603: object "SPX" of type DB_LINK not found in schema "IA"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 3912
ORA-06512: at "SYS.DBMS_METADATA", line 5678
ORA-06512: at line 1


Thanks and Regards,
VN