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

Question

-- 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)
)
)';

Answer 1

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