DROP DATABASELINK¶

说明¶

删除一个远程数据库连接

语法¶

drop_databaselink::=
            DROP [PUBLIC] DATABASELINK dblinkname;

参数¶

public

要删除的是public数据库链接。

dblinkname

远程数据库链接的名字。

示例¶

drop databaselink db_oscar;
drop public databaselink db_oscar1;

create databaselink db_oscar 
connect to sysdba identified by 
'szoscar55' using '10.0.4.59' port 2003 database 'osrdb';

create public databaselink db_oscar1 
connect to sysdba identified by 
'szoscar55' using '10.0.4.59' port 2003 database 'osrdb';

drop databaselink db_oscar;
drop public databaselink db_oscar1;