CREATE database link dblink_ciqmis CONNECT TO byciqmis IDENTIFIED BY byciqmis USING '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.247)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) )';