Distributed Data Access Across Multiple Oracle Databases
For many years, Oracle has offered access to distributed data residing on multiple
Oracle database servers on multiple systems or nodes. Users don??™t need to know the
location of the data in distributed databases. Data is accessed using a unique identifier
to a specific table name. Administrators can create simple identifiers so that data
in an Oracle table in a separate machine can appear to users to be part of a single logical
database.
306 | Chapter 13: Oracle Distributed Databases and Distributed Data
Developers can create connections between individual databases by creating database
links in SQL. These connections form a distributed database. The statement:
CREATE PUBLIC DATABASE LINK employees.northpole.bigtoyco.com
creates a path to a remote database containing a table with Bigtoyco??™s North Pole
employees. Any application or user attached to a local employees database can
access the remote North Pole database by using the global access name (employees.
northpole.
Pages:
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664