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.
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 e.last_name,j.job_title FROM employees@pittsburgh e, jobs@detroit j, job_history hWHERE e.job_id = j.job_id AND e.employee_id = h.employee_id AND h.end_date >= SYSDATE-30;
SELECT employee_id, end_date
SELECT last_name, job_id FROM employees;
SELECT job_id, job_title FROM jobs;
INSERT INTO jobs@detroit VALUES
('CEO','Chief Executive Officer',18000,34000);
SET job_id = 'CEO'
WHERE last_name = 'Hart';