hearimm · October 19, 2017 08:42
diff --git a/DATABASE_LINK.sql b/DATABASE_LINK.sql
 DROP PUBLIC DATABASE LINK LIVE;

 CREATE PUBLIC DATABASE LINK LIVE 
   CONNECT TO YOUR_USER_ID
   IDENTIFIED BY YOUR_PASSWORD
   USING 
   '(DESCRIPTION = 
        (ADDRESS_LIST = 
            (ADDRESS = (PROTOCOL = TCP)
                      (HOST = YOUR_HOST_ID)
                    (PORT = 1521)
            )
        )
        (CONNECT_DATA = (SID = YOUR_SID )
        )
    )
   ';
   
 --USAGE : SELECT * FROM YOUR_TABE@LIVE
	DROP PUBLIC DATABASE LINK LIVE;

	CREATE PUBLIC DATABASE LINK LIVE
	CONNECT TO YOUR_USER_ID
	IDENTIFIED BY YOUR_PASSWORD
	USING
	'(DESCRIPTION =
	(ADDRESS_LIST =
	(ADDRESS = (PROTOCOL = TCP)
	(HOST = YOUR_HOST_ID)
	(PORT = 1521)
	)
	)
	(CONNECT_DATA = (SID = YOUR_SID )
	)
	)
	';

	--USAGE : SELECT * FROM YOUR_TABE@LIVE
No results found