Oracle Transportable TableSpace(TTS) 传输表空间 说明.docxVIP

Transportable TableSpace(TTS) 说明官网的两篇相关文章：Transporting TablespacesBetween Databases/cd/E11882_01/server.112/e25494/tspaces013.htmCreating Transportable Tablespace Sets/cd/E11882_01/backup.112/e10642/rcmttbsb.htmTransportable TableSpaces(TTS)特性是从Oracle 8.1版本开始提供,在8i中，可以在同平台下进行TTS 操作。在10g以后TTS 得到增强，可以跨平台进行操作。1.1 Introduction to Transportable TablespacesYou can use the Transportable Tablespaces feature to copy a set of tablespaces from one Oracle Database to another.--可以使用TTS 特性将表空间从一个数据库copy 到另一个数据库。Note:This method for transporting tablespaces requires that you place the tablespaces to be transported in read-only mode until you complete the transporting process. If this is undesirable, you can use the Transportable Tablespaces from Backup feature, described in?Oracle Database Backup and Recovery Users Guide.--TTS 需要将传输的表空间至于read-only格式，直到传输操作完成，如果不能将表空间设置为read-only 模式，那么也可以使用基于Backup的TTS。The tablespaces being transported can be either dictionary managed or locally managed. Starting with Oracle9i, the transported tablespaces are not required to be of the same block size as the destination database standard block size.--使用本地管理或者数据字典管理的表空间可以被传输，从Oracle 9i开始，传输的表空间不需要和目标库相同的block size。关于表空间的类型，参考：Oracle 自动段空间管理(ASSM:auto segment space management)/tianlesoftware/article/details/4958989Moving data using transportable tablespaces is much faster than performing either an export/import or unload/load of the same data. This is because the datafiles containing all of the actual data are just copied to the destination location, and you use Data Pump to transfer only the metadata of the tablespace objects to the new database.--使用TTS 移动数据要比export/import 或unload/load 快很多，因为TTS数据的移动仅仅是datafile的一个copy 过程，TTS的Data Pump仅移动表空间对象的metadata.Note:Beginning with Oracle Database 11g Release 1, you must use Data Pump for transportable tablespaces. The only circumstance under which you can use the original import and export utilities, IMP and EXP, is for a backward migration of XMLType data to