关于create database link的问题。急，快点进来，谢谢

[sforat]

我是这样写的
create database link db1_link
connect to user identified by pwd
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = liuip)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = database_name)
)
)';


其实很简单，但是问题是执行报错。说 identified by pwd pwd有问题
我在考虑要不要加单引号'pwd' 加了也不行，不加也报错。为什么为什么？？急。

[sforat]

有人吗

[争取今天]

user 是oracle关键字,如果要用它做对象名,用双引号括上.
最后别用关键字,否则用起来也麻烦

[sforat]

我自己知道了。 原来密码不能数字开头。。。

[我心飞翔]

呵呵，一场虚惊!
不过还是恭喜一下了。

[rfb0204421]

[tlx20093A]

这样也行：
create database link db1_link
connect to
username identified by pwd
using 'oracle_sid';

[s3068770]

(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = liuip)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = database_name) ) )
不能有换行。

[qinglang1987]

[Quote=引用楼主 sforat 的回复:]
我是这样写的
create database link db1_link
connect to user identified by pwd
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = liuip)(PORT = 1521))
)
(CONNECT_DAT……
[/Quote]

pwd 两边加上双引号“” 不是单引号‘’

[qinglang1987]

create database link db1_link
connect to user identified by "pwd"
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = liuip)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = database_name)
)
)';


这样就好了