发表于:2008.03.06 16:21
分类: Oracle
出处：http://xsb.itpub.net/post/419/456615
---------------------------------------------------------------
Solution1:
source：windows2003 32bit,oracle10g 10.2.0.2
target:IBM aix 64bit,oracle10g 10.2.0.3,RAC,ASM
Solution2:
source：HP UX 64bit,oracle10g 10.2.0.3,RAC,ASM
target:IBM aix 64bit,oracle10g 10.2.0.3,RAC,ASM
Solution1:
source：windows2003 32bit,oracle10g 10.2.0.2
GRANT DBA TO xsb IDENTIFIED BY xsb;
CREATE TABLESPACE xsbtest_ts DATAFILE 'D:ORACLEPRODUCT10.2.0ORADATACSLSCxsbtest_ts01.DBF' SIZE 5m;
SELECT * FROM v$datafile;
CREATE TABLE xsb.t1 TABLESPACE xsbtest_ts AS SELECT * FROM dba_users;
SELECT * FROM xsb.t1;
ALTER TABLESPACE xsbtest_ts READ ONLY;
SELECT *FROM v$transportable_platform ORDER BY platform_id;
--conn sys AS SYSDBA
--BEGIN dbms_tts.transport_set_check('xsbtest_ts', TRUE,TRUE);END;
--SELECT * FROM TRANSPORT_SET_VIOLATIONS;
exp 'sys AS SYSDBA' FILE=1.dmp tablespaces=xsbtest_ts transport_tablespace=y
ftp target
bin
put D:ORACLEPRODUCT10.2.0ORADATACSLSCxsbtest_ts01.DBF
bye
ALTER TABLESPACE xsbtest_ts READ WRITE;
target:IBM aix 64bit,oracle10g 10.2.0.3,RAC,ASM
GRANT DBA TO xsb IDENTIFIED BY xsb ;
--DROP TABLESPACE xsbtest_ts INCLUDING CONTENTS and datafiles ;
rman target /
CONVERT DATAFILE '/home/oracle/XSBTEST_TS01.DBF' FROM PLATFORM 'Microsoft Windows IA (32-bit)'
format '+DATA/aeg2t/datafile/xsbtest_ts.dbf' ;
EXIT
imp 'sys as sysdba ' file=1.dmp tablespaces=xsbtest_ts transport_tablespace=y datafiles='+DATA/aeg2t/datafile/xsbtest_ts.dbf'
SELECT * FROM xsb.t1;
Solution2:
source：HP UX 64bit,oracle10g 10.2.0.3,RAC,ASM
GRANT DBA TO xsb IDENTIFIED BY xsb;CREATE TABLESPACE xsbtest_ts2 DATAFILE SIZE 5m;
SELECT * FROM dba_data_files;
CREATE TABLE xsb.t1 TABLESPACE xsbtest_ts2 AS SELECT * FROM dba_users;
SELECT * FROM xsb.t1;
ALTER TABLESPACE xsbtest_ts2 READ ONLY;
SELECT * FROM dba_tablespaces;
SELECT *FROM v$transportable_platform ORDER BY platform_id;
--conn sys AS SYSDBA
--BEGIN dbms_tts.transport_set_check('xsbtest_ts2', TRUE,TRUE);END;
--SELECT * FROM TRANSPORT_SET_VIOLATIONS;
show parameter comp
exp 'SYS AS SYSDBA ' FILE=1.dmp tablespaces=xsbtest_ts2 transport_tablespace=y
rman target /
copy DATAFILE ## TO '/home/oracle/xsbtest_ts2.dbf' ;
or
CONVERT TABLESPACE xsbtest_ts2 TO platform 'AIX-Based Systems (64-bit)' format '/home/oracle/xsbtest_ts2.dbf';
EXIT
ALTER TABLESPACE xsbtest_ts2 READ WRITE;
--DROP TABLESPACE xsbtest_ts2 INCLUDING CONTENTS and datafiles ;
--drop user xsb cascade;
ls -lt|more
ftp target
bin
put /home/oracle/xsbtest_ts2.dbf
put /home/oracle/1.dmp
bye
target:IBM aix 64bit,oracle10g 10.2.0.3,RAC,ASM
GRANT DBA TO xsb IDENTIFIED BY xsb ;
--DROP TABLESPACE xsbtest_ts2 INCLUDING CONTENTS and datafiles ;
rman target /
CONVERT DATAFILE '/home/oracle/xsbtest_ts2.dbf' format '+DATA/aeg2t/datafile/xsbtest_ts2.dbf' ;
EXIT
show parameter comp
imp 'sys as sysdba ' file=1.dmp tablespaces=xsbtest_ts2 transport_tablespace=y datafiles='+DATA/aeg2t/datafile/xsbtest_ts2.dbf'
SELECT * FROM xsb.t1;
re: oracle10g ASM transport_tablespace