Thursday, January 28, 2010

SQL Oracle Command

CREATE DATABASE link
--------------------
CREATE DATABASE link link_name CONNECT TO user_nameIDENTIFIED BY use_pwd USING 'host:port/service_name';

Test the created Link
----------------------
select * from dual@"link_name";