[bbk5227] 第112集 -第14章 - 数据库空间管理 01

Imp、exp、impdp、expdp都是属于逻辑导出数据，也就是说需要逐个将元数据及数据本身导出导入.

采用可传输表空间的移植数据，是最快移植数据方式.

可传输表空间，支持跨平台，不同的平台间的数据移植.

平台不一样，文件的高地位编码就不一样.但是两个平台之间要有相同的字符集.

Transporting Tablespaces

• Cross-platform transportable tablespaces:
  • -Simplify moving data between data warehouse and data marts
  • -Allow database migration from one platform to another 
• Supported platforms include:

Concept:Minimum Compatibility Level

• Both source and target databases must have COMPATIBLE set to 10.0.0 or higher
• Data file headers are platform-aware.
• Before transporting,make sure that all read-only and offline files are platform-aware

Minimum Compatibility Level

Transportable Tablespace Procedure

 

Determing the Endian Format of a Platform

SQL> select tp.endian_format
  2  from v$transportable_platform tp,v$database d
  3  where tp.platform_name = d.platform_name;

ENDIAN_FORMAT
--------------
Little

 

什么是大字节编码：将内存的高位写到磁盘文件的高位，将内存的低位写到磁盘文件的低位.

什么事小字节编码：将内存的高位写到磁盘文件的低位，将内存的低位写到磁盘文件的高位.

Using the RMAN convert Command

RMAN:

• Converts tablespaces,data files,or databases to the format of a destination platform
• Does not change imput files
• Writes converted files to output destination

CONNECT TARGET SYS@orcl

RMAN>

SQL 'ALTER TABLESPACE hr READ ONLY';

CONVERT TABLESPACE hr

 TO PLATFORM 'Solaris[tm] OE (64-bit)'

 FORMAT '/tmp/transport_to_solaries/%U';