Metadata (the
data dictionary) is exported from the source and imported to the target. The
transferred tablespace can then be mounted on the target. Oracle Database 10g
introduced cross-platform Transportable Tablespaces, which can move a
tablespace from one type of system (e.g., Solaris) to another (e.g., Linux).
Oracle Streams
Streams have been bundled with Oracle since Oracle9i Release 2. Oracle Streams
include Oracle??™s log-based replication, Advanced Queues (AQ), and since Oracle
Database 10g, includes Transportable Tablespaces. Streams are often used
for near real-time data movement. Oracle Database 10g added support for
downstream capture, which allows changed data to be collected from log files,
eliminating overhead, RMAN and Transportable Tablespaces for instantiation,
support for LONG, LONG RAW, and NCLOB datatypes, and asynchronous
change data capture that uses Streams to transport only changed records from a
source database to a target.
Data Pump Fast Import/Export
Added in Oracle Database 10g and enabled via external table support, Data
Pump is a newer import/export format.
Pages:
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528