create dblink three mothod:
1.CREATE PUBLIC DATABASE LINK hq USING 'hq';
A local user accessing a database link in which no fixed username and password have been specified. If SYSTEM accesses a public link in a query, then the connected user is SYSTEM, and Oracle connects to the SYSTEM schema in the remote database.
2.CREATE PUBLIC DATABASE LINK hq CONNECT TO CURRENT_USER using 'hq';
A global user in a CURRENT_USER database link. The global user must be authenticated by an X.509 certificate (an SSL-authenticated enterprise user) or a password (a password-authenticated enterprise user), and be a user on both databases involved in the link. Current user links are an aspect of the Oracle Advanced Security option.
3.CREATE PUBLIC DATABASE LINK hq CONNECT TO jane IDENTIFIED BY doe USING 'hq';
A user whose username/password is part of the link definition. If a link includes a fixed user, then the fixed user's username and password are used to connect to the remote database.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/519130/viewspace-912850/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/519130/viewspace-912850/