In addition to providing underlying SQL services, Heterogeneous Services
provide transaction services utilizing Oracle??™s two-phase commit with non-Oracle
databases and procedural services that call third-generation language routines on
non-Oracle systems. Users interact with the Oracle database as if all objects are
stored in the Oracle database, and Heterogeneous Services handle the transparent
interaction with the foreign database on the user??™s behalf.
Data Movement Features
Moving data from one Oracle database to another is often a requirement when using
distributed databases, or when a user wants to implement multiple copies of the
same database in multiple locations to reduce network traffic or increase data availability.
Youcan export data and data dictionaries (metadata) from one database and
import them into another. Oracle Database 10g introduced a high-speed data pump
for the import and export.
Oracle also offers many other advanced features in this category, including transportable
tablespaces, Advanced Queuing/Oracle Streams, and extraction, transformation
and loading (ETL) solutions.
Pages:
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73