将Linux平台上的源数据库中的tspitr与test表空间传输到AIX平台上。并在源主机上使用目录/u02/transport来存储被转换的数据文件。
将Linux平台上的源数据库中的tspitr与test表空间传输到AIX平台上。并在源主机上使用目录/u02/transport来存储被转换的数据文件。操作步骤如下:
1.将要被传输的表空间tspitr与test设置为只读
SQL> alter tablespace tspitr read only;
Tablespace altered.
SQL> alter tablespace test read only;
Tablespace altered.
2.检查源平台与目标平台信息支不支持传输操作
数据库所支持的平台信息:
SQL> select platform_name,endian_format from v$transportable_platform;
PLATFORM_NAME ENDIAN_FORMAT
-------------------------------------------------------------------------------- --------------
Solaris[tm] OE (32-bit) Big
Solaris[tm] OE (-bit) Big
Microsoft Windows IA (32-bit) Little
Linux IA (32-bit) Little
AIX-Based Systems (-bit) Big
HP-UX (-bit) Big
HP Tru UNIX Little
HP-UX IA (-bit) Big
Linux IA (-bit) Little
HP Open VMS Little
Microsoft Windows IA (-bit) Little
IBM zSeries Based Linux Big
Linux x86 -bit Little
Apple Mac OS Big
Microsoft Windows x86 -bit Little
Solaris Operating System (x86) Little
IBM Power Based Linux Big
Solaris Operating System (x86-) Little
HP IA Open VMS Little
源平台:
SQL> select d.platform_name,endian_format from v$transportable_platform tp,v$database d where tp.platform_name=d.platform_name ;
