Database Link to HRDW

General SQL shell to:

CREATE DATABASE LINK somelinkName
connect to someusername identified by somepassword
USING '(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=odb34.pvt.hawaii.edu)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=hrdwtst.db.uh)) )';

Shorter method to do the same:

CREATE DATABASE LINK somelinkName
connect to someusername identified by somepassword
USING 'odb34.pvt.hawaii.edu:1521/hrdwtst.db.uh';


Actual SQLs that were run in production:

DROP DATABASE LINK DATAWAREDB_LINK.DB.UH; 

CREATE DATABASE LINK DATAWAREDB_LINK.DB.UH
connect to adminapp identified by somepassword
USING 'odb34.pvt.hawaii.edu:1521/hrdw.db.uh';`

Before running the above SQL

you can setup a separate database link and run the same SQL on both links to compare the data and verify that they are identical:

ex:

a) select * from edadba.pay_acct_chg_hist@hrdw_link_odb34.db.uh where employee_alt_id= ' ';

b) select * from edadba.pay_acct_chg_hist@hrdw_link.db.uh where employee_alt_id= ' ';



Related Jiras: