Oracle 10g同字节序跨平台迁移

在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

Oracle利用存储过程造数据详析Oracle跟踪事件:set events相关资讯 oracle

[INS-32052] Oracle基目录和Oracle （07/22/2014 07:41:41）
Oracle 4个大对象（lobs）数据类型（02/03/2013 12:33:05）
Oracle按时间段分组统计（07/26/2012 10:36:48）

[Oracle] dbms_metadata.get_ddl的（07/12/2013 07:37:30）
Liferay Portal 配置使用Oracle和（07/31/2012 20:07:18）
Concurrent Request:Inactive （07/20/2012 07:44:05）

本文评论查看全部评论（0）