oracle dul 11

前端之家收集整理的这篇文章主要介绍了oracle dul 11前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

联系:手机(+86 13429648788)QQ(107644445)

标题oracle dul 11 正式发布

作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]

千呼万唤oracle dul 11终于发布了,迫不及待的下载来测试,现在版本号为dul 11.2.0.0.1,目前只发布了for linux,其他版本估计要等等.期待该版本有引进新功能
oracle dul 11发布



dul 11 测试恢复oracle 12c版本

[root@ora1221 dul11] # ./dul
Data UnLoader: 11.2.0.0.1 - Internal Only - on Mon Jun 13 00:04:50 2016
with 64-bit io functions
Copyright (c) 1994 2016 Bernard van Duijnen All rights reserved.
Strictly Oracle Internal Use Only
DUL: Warning: Recreating @H_404_65@file "dul.log"
Found db_id = 1414800805
Found db_name = ORCL
DUL> bootstrap;
Probing file = 1,block = 520
. unloading table BOOTSTRAP$
DUL: Warning: block number is non zero but marked deferred trying to process it anyhow
60 rows unloaded
DUL: Warning: Dictionary cache DC_BOOTSTRAP is empty
Reading BOOTSTRAP.dat 60 entries loaded
Parsing Bootstrap$ contents
"dict.ddl"
Generating dict.ddl for version 12
OBJ$: segobjno 18, 1 block 240
TAB$: segobjno 2,tabno 1,monospace!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.1em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; top:auto!important; width:auto!important; direction:ltr!important; display:inline!important"> 1 block 144
COL$: segobjno 2,tabno 5,monospace!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.1em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; top:auto!important; width:auto!important; direction:ltr!important; display:inline!important"> 1 block 144
USER$: segobjno 10,monospace!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.1em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; top:auto!important; width:auto!important; direction:ltr!important; display:inline!important"> 1 block 208
Running generated "@dict.ddl" to unload the dictionary tables
. unloading table OBJ$ 72547 rows unloaded
. unloading table TAB$ 2137 rows unloaded
. unloading table COL$ 115645 rows unloaded
. unloading table USER$ 129 rows unloaded
Reading USER.dat 129 entries loaded
Reading OBJ.dat
DUL: FATAL Error: File OBJ.dat,line 22094: identifier too long

dul 11 恢复oracle 12c 报错分析
看报错OBJ.dat报错数据,从定义上判断是长度过长

# vi OBJ.dat
22091 "22435" "" "0" "JVMFCB" "9" ""
22092 "22436" "11" ""
22093 "22437" "56417" "JAVA$CBOBJ$" "2" ""
---- 22094 "22439" "sun/util/xml/PlatformXmlPropertiesProvider$Resolver" "29" ""
22095 "22440" "sun/util/xml/PlatformXmlPropertiesProvider$EH" ""
22096 "22441" "sun/util/xml/PlatformXmlPropertiesProvider$1" ""
22097 "22442" "sun/util/resources/LocaleNamesBundle" ""

对象名长度分析

[oracle@ora1221 ~]$ ss
sql*Plus: Release 12.2.0.0.3 Production on Fri Aug 7 02:50:35 2015
Copyright (c) 1982,2016,Oracle. All rights reserved.
Connected to :
Oracle Database 12c Enterprise Edition Release 12.2.0.0.3 - 64bit Production
sql> select length(object_name) from dba_objects
2 where object_name= 'sun/util/xml/PlatformXmlPropertiesProvider$Resolver' ;
LENGTH(OBJECT_NAME)
-------------------
51
select max (length(object_name)) dba_objects;
MAX (LENGTH(OBJECT_NAME))
------------------------
123
desc dba_objects
Name Null ? Type
----------------------------------------- -------- ----------------------------
OWNER VARCHAR2(128)
OBJECT_NAME VARCHAR2(128)
SUBOBJECT_NAME VARCHAR2(128)
OBJECT_ID NUMBER
DATA_OBJECT_ID NUMBER
OBJECT_TYPE VARCHAR2(23)
CREATED DATE
LAST_DDL_TIME DATE
TIMESTAMP VARCHAR2(19)
STATUS VARCHAR2(7)
TEMPORARY VARCHAR2(1)
GENERATED VARCHAR2(1)
SECONDARY VARCHAR2(1)
NAMESPACE NUMBER
EDITION_NAME VARCHAR2(128)
SHARING VARCHAR2(18)
EDITIONABLE VARCHAR2(1)
ORACLE_MAINTAINED VARCHAR2(1)
APPLICATION VARCHAR2(1)
DEFAULT_COLLATION VARCHAR2(100)
DUPLICATED VARCHAR2(1)
SHARDED VARCHAR2(1)
CREATED_APPID NUMBER
CREATED_VSNID NUMBER
MODIFIED_APPID NUMBER
MODIFIED_VSNID NUMBER

在oracle 12c中对象名长度已经变为128,但是dul依旧不能支持列长度,既然作者已经在init.dul的Compatible参数曾增加了对12c的支持,那对这样明显的bug应该在不久的将来即可修复。当然这个问题,可以通过一些人工技巧绕过去

猜你在找的Oracle相关文章