database link does not exists but possible to access
Hi All
I have a case that I don't get.
I have these database links
select owner, db_link from dba_db_links
OWNER DB_LINK
------------------------------ -------------------------------------------
OWBUSER OWB_34.REGRESS.RDBMS.DEV.US.ORACLE.COM
OWBUSER OWB_22.REGRESS.RDBMS.DEV.US.ORACLE.COM
AP2DW TEST.AP2.SE
AP2DW SCPROD.AP2.SE@AP2DW_CONN1
AP2DW DW_VISMA.AP2.SE@VISMA_LOCATION_0
AP2DW DWDEV_AP2DW.AP2.SE
I have a sql that refrences this database_link SCPROD@AP2DW_CONN1
If I execute a simple select using the link I got rows back, shouldn't I get
ORA-02019: connection description for remote database not found
select count(1) from SCDAT.A_HOLKEYS@SCPROD@AP2DW_CONN1;
COUNT(1)
----------
407615
Obviously I'm missing something but right now I can't figure it out
Global_name = false
domain_name is unset
Anyone that can help me ?
Thanks
Magnus