Previously, tablespaces
needed to be exported from the source database and imported at the target (or
unloaded and loaded). Transportable tablespaces enable copies to be moved simply
through the use of file transfer commands such as ftp.
Before youcopy and move a copy of the tablespace, youshou ld make the tablespace
read-only to avoid inadvertently changing it. Data dictionary information needs to be
exported from the source prior to transfer, then imported at the target.
Some of the most popular reasons to use transportable tablespaces include:
??? Rapid copying of tablespaces from enterprise data warehouses to data marts
??? Copying of tablespaces from operational systems to operational data stores for
use in consolidated reporting
??? Publishing of tablespaces for distribution on CD-ROM
??? Use of backup copies for rapid point-in-time tablespace recovery
Oracle9i eliminated the restriction that Oracle block sizes needed to be the same in
both the source and target databases. Oracle Database 10g eliminated the restriction
that the source and target databases needed to be running on the same operating system
platform.
Pages:
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690