9/25/09

Syntax for creating Oracle database link

Syntax to create a database link to a target oracle database from another oracle database:
create database link TARGETDB connect to USERID identified by "PASSWORD" using 'TARGETDB';

Now from SOURCEDB the below query will get results from the TARGETDB:
SELECT * FROM TABLENAME@TARGETDB;

General syntax:
create database link LINKNAME connect to USERNAME identified by "PASSWORD" using 'DBNAME';

This has to be executed in oracle source database and not in destination database.

No comments:

Post a Comment

Please refrain for marketing messages and unnecessary back links.

Workflow errors on New Hire and Add employment instance

User tries to hire a new person or tries to add a new organization relationship encounters a series of error messages related to workflow...

Trending in this Blog this month