weixin_41931064 2018-10-15 12:03 采纳率: 16.7%
浏览 716
已采纳

oracle数据库建立databaselinks连接报错ORA-00900

-- Drop existing database link
drop public database link A5;
-- Create database link
create public database link A5
connect to CYC_YSL identified by cyc_ysla5;
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =10.30.111.84)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME =doea5dr)
)
)';

  • 写回答

2条回答 默认 最新

  • 六月大雪纷飞 2018-10-16 01:40
    关注

    ORA-00900是无效的sql,错误在connect to CYC_YSL identified by cyc_ysla5;删掉最后面的‘;’

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?