We introduce these next.
Transportable Tablespaces
Transportable tablespaces first appeared in Oracle8i. Instead of using the export/
import process, which dumps data and the structures that contain it into an intermediate
file for loading, youcan place a tablespace in read-only mode, move or copy it
from one database to another, and then mount it. The same data dictionary (metadata)
describing the tablespace must exist on the source and the target. This feature
can save a lot of time since it simplifies the movement of large amounts of data.
Data Movement Features | 19
Starting with Oracle Database 10g, youcan move data with transportable tablespaces
between heterogeneous platforms or operating systems.
Advanced Queuing and Oracle Streams
Advanced Queuing (AQ), first introduced in Oracle8, provides the means to asynchronously
send messages from one Oracle database to another. Because messages
are stored in a queue in the database and sent asynchronously when a connection is
made, the amount of overhead and network traffic is much lower than it would be
using traditional guaranteed delivery through the two-phase commit protocol
between source and target.
Pages:
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74