Enabling Distributed Transactions. Objectives. After completing this lesson, you should be able to: Verify network configuration Explain the differences between remote transactions and distributed transactions Establishing communication between databases through database links. sqlnet.ora.
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
listener.oraOracle Net Services Review
CREATE DATABASE LINK hq.sales.acme.com
CONNECT TO hr IDENTIFIED BY hr
CREATE PUBLIC DATABASE LINK orcl USING 'ORCL';
SELECT * FROM
DROP [PUBLIC] DATABASE LINK linkname;
PittsburghExecuting a Distributed Query
SELECT employee_id, end_date
SELECT last_name, job_id FROM employees;
SELECT job_id, job_title FROM jobs;