Oracle10g同字节序跨平台迁移-mysql教程

在Oracle 10g中，同字节序跨平台的文件头信息Oracle会自动改写，不再需要转换。 我们看以下测试： [oracle@danaly ora

　　在Oracle 10g中，同字节序跨平台的文件头信息Oracle会自动改写，不再需要转换。

　　我们看以下测试：

　　[oracle@danaly oradata]$ sqlplus "/ as sysdba"

　　SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jul 12 15:14:21 2007

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

　　Connected to:

　　Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

　　With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options

　　SQL> alter database mount;

　　Database altered.

　　SQL> alter database open;

　　Database altered.

　　SQL> select name from v$datafile;

　　NAME

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

　　/opt/oracle/oradata/eygle/EYGLE/datafile/o1_mf_system_37tc1xns_.dbf

　　/opt/oracle/oradata/eygle/EYGLE/datafile/o1_mf_undotbs1_37tc29mb_.dbf

　　/opt/oracle/oradata/eygle/EYGLE/datafile/o1_mf_sysaux_37tc2gqc_.dbf

　　/opt/oracle/oradata/eygle/EYGLE/datafile/o1_mf_users_37tc2tth_.dbf

　　SQL> show parameter comp

　　NAME TYPE VALUE

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

　　compatible string 10.2.0.1.0

　　nls_comp string

　　plsql_compiler_flags string INTERPRETED, NON_DEBUG

　　plsql_v2_compatibility boolean FALSE

　　SQL> create tablespace trans

　　2 datafile '/opt/oracle/oradata/eygle/EYGLE/datafile/trans.dbf' size 10M;

　　Tablespace created.

　　SQL> create user trans identified by trans default tablespace trans;

　　User created.

　　SQL> grant connect,resource to trans;

　　Grant succeeded.

　　SQL> connect trans/trans

　　create table test as select * from dict;

　　Connected.

　　SQL>

　　Table created.

　　SQL> select count(*) from test;

　　COUNT(*)

　　----------

　　615

　　SQL> connect / as sysdba

　　Connected.

　　SQL> alter tablespace trans read only;

　　Tablespace altered.

　　SQL> exit

　　Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

　　With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options

　　[oracle@danaly oradata]$ exp \'/ as sysdba\' tablespaces=trans transport_tablespace=y file=exp_trans.dmp

　　Export: Release 10.2.0.1.0 - Production on Thu Jul 12 15:28:24 2007

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

　　Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

　　With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options

　　Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set

　　Note: table data (rows) will not be exported

　　About to export transportable tablespace metadata...

　　For tablespace TRANS ...

　　. exporting cluster definitions

　　. exporting table definitions

　　. . exporting table TEST

　　. exporting referential integrity constraints

　　. exporting triggers

　　. end transportable tablespace metadata export

　　Export terminated successfully without warnings.

　　[oracle@danaly oradata]$ ls -l exp_trans.dmp

　　-rw-r--r-- 1 oracle dba 16384 Jul 12 15:28 exp_trans.dmp

　　[oracle@danaly oradata]$ pwd

　　/opt/oracle/oradata