当前位置:Gxlcms > 数据库问题 > 创建密码带有特殊字符的dblink

创建密码带有特殊字符的dblink

时间:2021-07-01 10:21:17 帮助过:27人阅读

database link to_test   connect to scott identified by "tiger.1"   using (DESCRIPTION =   (ADDRESS_LIST =   (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))   )   (CONNECT_DATA =    (SERVER = DEDICATED)    (SERVICE_NAME = bylw)   ) )
xxx.xxx.xxx.xxx是要连接的数据库ip
我的密码中有. 属于特殊字符,必须加""才能通过。

用法:
首选备份表:create table t_wfd_process_info20170918 as select * from t_wfd_process_info
然后删除旧表:delete from t_wfd_process_info
之后将xxx.xxx.xxx.xxx表中的数据塞入本数据库的表中:insert into t_bpm_group select * from t_bpm_group@TO143

创建密码带有特殊字符的dblink

标签:service   创建   des   col   delete   ide   code   int   ica   

人气教程排行