blog 结构图&＃xff1a;

p_w_picpath

 

1  场景描述

源平台为&＃xff1a;windows xp 32系统 &＃43; oracle 11.2.0.1.0  &＃43; ORACLE_SID&＃61;orcl

目标平台&＃xff1a;rhel6.5 &＃43; oracle 11.2.0.1.0 &＃43; asm 64位 &＃43; ORACLE_SID&＃61;orclasm

目标&＃xff1a;要实现将自定义的应用程序表空间app1tbs,app2tbs,idxtbs从源平台传递到目标平台

 

注&＃xff1a;

 

①　从linux到windows 下参考&＃xff1a; http://blog.itpub.net/26736162/viewspace-1375260/

②　source和target database的数据库版本最好一致&＃xff0c;否则会因为db time zone 不一致导致报如下错误&＃xff0c;但是source如果大于target的话是可以的&＃xff0c;向下兼容的
ORA-39002: invalid operation

ORA-39322: Cannot use transportabletablespace with timestamp with timezone columns and different timezone version.

 

 

 

wps2A1B.tmp 

 

2  环境准备

wps2A1C.tmp 

 

2.1  在源库上创建3个用户应用的表空间

C:\Users\Administrator>sqlplus lhr/lhr&＃64;orclxp

 

SQL*Plus: Release 11.2.0.1.0 Production on 星期一 5 17:15:22 2015

 

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

 

 

连接到8行。

 

SQL>

SQL>

 

2.2  在相应的表空间创建表和索引

SQL> create table scott.app1_tab tablespace app1tbs as select * from scott.emp;

 

Table created.

 

SQL> create table scott.app2_tab tablespace app2tbs as select * from scott.dept;

 

Table created.

 

SQL> create index scott.idx_emp_ename on scott.app1_tab(ename) tablespace idxtbs;

 

Index created.

 

SQL> create index scott.idx_dept_dname on scott.app2_tab(dname) tablespace idxtbs;

 

Index created.

 

SQL>

 

 

 

3  判断平台支持并确定字节序

如果传输表空间集到不同的平台&＃xff0c;则要确定对于源和目标平台这种跨平台表空间被支持&＃xff0c;也要确定每个平台的字节序&＃xff0c;如果平台具有相同的字节序&＃xff0c;则不需要进行转化&＃xff0c;否则必须做一个表空间集转化&＃xff0c;在源端或目标端。

3.1  在源平台查询

SQL> col platform_name for a40

SQL> select d.platform_name,tp.endian_format from v$transportable_platform tp,v$database d

  2  where tp.platform_name&＃61;d.platform_name;

 

PLATFORM_NAME                            ENDIAN_FORMAT

---------------------------------------- --------------

Microsoft Windows IA (32-bit)            Little

 

 

结论&＃xff1a;当前的系统平台支持跨平台表空间传输&＃xff08;因为上面的查询有记录返回&＃xff09;

 

3.2  在目标平台查询

 

SQL> col platform_name for a40

SQL> select d.platform_name,tp.endian_format from v$transportable_platform tp,v$database d

  2  where tp.platform_name&＃61;d.platform_name;

 

PLATFORM_NAME ENDIAN_FORMAT

---------------------------------------- --------------

Linux x86 64-bit Little

 

SQL>

 

 

 

结论&＃xff1a; 当前的平台支持跨平台的表空间传输源平台和目标平台的Endian_format 相同&＃xff08;均为Little&＃xff09;&＃xff0c;不需要进行表空间集转换

 

4  选择自包含的表空间集&＃xff08;目前要传输app1tbs和idxtbs这2个表空间&＃xff09;

4.1  进行检查

Indicates whether a full or partial dependency check is required. If TRUE, treats all IN and OUT pointers(dependencies) and captures them as violations if they are not self-contained in the transportable set.

SQL> execute sys.dbms_tts.transport_set_check(&＃39;app1tbs,idxtbs&＃39;,true);

 

PL/SQL procedure successfully completed.