A database link (dblink) links databases. It allows you to query against other databases using the syntax TABLENAME@DBLINK.
In a scenario where you are trying to access the finance data from HCM environment,at that particular point you can create a DB link to do the same.
CREATE public database link DBlink Name CONNECT TO Username IDENTIFIED BY password using 'databasename';
PS:In order to execute this query use a data mover.
In a scenario where you are trying to access the finance data from HCM environment,at that particular point you can create a DB link to do the same.
CREATE public database link DBlink Name CONNECT TO Username IDENTIFIED BY password using 'databasename';
PS:In order to execute this query use a data mover.
No comments:
Post a Comment