When you wanted to have tables of different database server then go for creating a database link. The syntax for creating the link is
Create database link <linkname>
connect to <user> identified by <pwd>
using 'service name';
The above is for creating a private fixed link. The service name is the alias name given in the TNS entry file. If in case it is not able to read the host properly then copy the description part of the TNS instead of service name.
Create database link <linkname>
connect to <user> identified by <pwd>
using 'service name';
The above is for creating a private fixed link. The service name is the alias name given in the TNS entry file. If in case it is not able to read the host properly then copy the description part of the TNS instead of service name.
No comments:
Post a Comment