Oracle10g同字节序跨平台迁移

来源:Oracle认证    发布时间:2012-11-12    Oracle认证视频    评论

  在Oracle10g中,同字节序跨平台的文件头信息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

上一页123456下一页

视频学习

我考网版权与免责声明

① 凡本网注明稿件来源为"原创"的所有文字、图片和音视频稿件,版权均属本网所有。任何媒体、网站或个人转载、链接转贴或以其他方式复制发表时必须注明"稿件来源:我考网",违者本网将依法追究责任;

② 本网部分稿件来源于网络,任何单位或个人认为我考网发布的内容可能涉嫌侵犯其合法权益,应该及时向我考网书面反馈,并提供身份证明、权属证明及详细侵权情况证明,我考网在收到上述法律文件后,将会尽快移除被控侵权内容。

最近更新

社区交流

考试问答