Test new features of oracle dul 11

Oracle dul 11 has finally been released. You can't wait to download it for testing. The current version is dul 11.2.0.0.1. Currently, only for linux is released, and other versions are expected to be released.

Oracle dul 11 released
Dul-11.2
Oracle-dul-11
Dul 11 test restoring 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 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
DUL: Warning: Recreating file "dict. ddl"
Generating dict. ddl for version 12
OBJ $: segobjno 18, file 1 block 240
TAB $: segobjno 2, tabno 1, file 1 block 144
COL $: segobjno 2, tabno 5, file 1 block 144
USER $: segobjno 10, tabno 1, file 1 block 208
Running generated file "@ 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

Error analysis of restoring oracle 12c during dul 11

If the OBJ. dat error data is returned, it is determined that the length is too long.

[Root @ ora1221 dul11] # vi OBJ. dat
22091 "22435" 0 "" JVMFCB "9 """
22092 "22436" 0 "" JVMFCB "11 """
22093 "22437" "56417" "0" "JAVA $ CBOBJ $" 2 """
---- 22094 "22439" 0 "" sun/util/xml/PlatformXmlPropertiesProvider $ Resolver "29 """
22095 "22440" 0 "" sun/util/xml/PlatformXmlPropertiesProvider $ EH "29 """
22096 "22441" 0 "" sun/util/xml/PlatformXmlPropertiesProvider $1 "29 """
22097 "22442" 0 "" sun/util/resources/LocaleNamesBundle "29 """
Object name length analysis
[Oracle @ ora1221 ~] $ Ss
 
SQL * Plus: Release 12.2.0.0.3 Production on Fri Aug 7 02:50:35 2015
 
Copyright (c) 1982,201 6, Oracle. All rights reserved.
 
 
Connected:
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
 
SQL> select max (length (object_name) from dba_objects;
 
MAX (LENGTH (OBJECT_NAME ))
------------------------
123
 
SQL> 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

In oracle 12c, the object name length has changed to 128, but dul still cannot support the column length. the dul Compatible parameter has added support for 12c, so the obvious bug should be fixed in the near future. Of course, this problem can be solved through some manual skills.