您好,欢迎来到三六零分类信息网!老站,搜索引擎当天收录,欢迎发信息

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

2024/3/10 10:51:11发布30次查看
在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

该用户其它信息

VIP推荐

免费发布信息,免费发布B2B信息网站平台 - 三六零分类信息网 沪ICP备09012988号-2
企业名录 Product