Transport of Tablespaces Between Databases (59)

tsinglee發表於2007-10-15

A transportable tablespace lets you move a subset of an Oracle database from one
Oracle database to another, even across different platforms. You can clone a tablespace
and plug it into another database, copying the tablespace between databases, or you
can unplug a tablespace from one Oracle database and plug it into another Oracle
database, moving the tablespace between databases.
Moving data by transporting tablespaces can be orders of magnitude faster than either
export/import or unload/load of the same data, because transporting a tablespace
involves only copying datafiles and integrating the tablespace metadata. When you
transport tablespaces you can also move index data, so you do not have to rebuild the
indexes after importing or loading the table data.
You can transport tablespaces across platforms. (Many, but not all, platforms are
supported for cross-platform tablespace transport.) This can be used for the following:
■ Provide an easier and more efficient means for content providers to publish
structured data and distribute it to customers running Oracle on a different
platform
■ Simplify the distribution of data from a data warehouse environment to data
marts which are often running on smaller platforms
■ Enable the sharing of read only tablespaces across a heterogeneous cluster
■ Allow a database to be migrated from one platform to another

資料庫間傳輸表空間
可傳輸表空間 :一個Oracle資料庫的子集嵌入 ,遷移 , 複製至另外一個資料庫 ,即使是在不同的表平臺上.
相比於匯入匯出/裝載資料 , 透過傳輸表空間來遷移資料的速度是數量級的 , 因為他只涉及到複製資料檔案和
整合表空間後設資料 , 在傳輸表空間時 , 也可以遷移索引並且不用重建

[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-976746/,如需轉載,請註明出處,否則將追究法律責任。

相關文章