Oracle 10 Gb cross-platform migration in the same byte sequence

In Oracle10g, Oracle will automatically rewrite the file header information across platforms in the same byte sequence, and no conversion is required. See the following test: [oracle @ danalyora

In Oracle 10 Gb, Oracle will automatically rewrite the file header information across platforms in the same byte sequence, and no conversion is required. Let's take a look at the following test: [oracle @ danaly ora

In Oracle 10 Gb, Oracle will automatically rewrite the file header information across platforms in the same byte sequence, and no conversion is required.

Let's take a look at the following tests:

[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,200 5, Oracle. All rights reserved.

Connected:

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 10 M;

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,200 5, 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 -- 1 oracle dba 16384 Jul 12 exp_trans.dmp

[Oracle @ danaly oradata] $ pwd

/Opt/oracle/oradata

,