DUL10直接支持ORACLE 8.0

郑全

在以前的文章中,写过DUL挖ORACLE 8.0数据库,使用的是dul 8的版本,现在测试dul 10直接支持ORACLE 8.0数据库
数据库版本 ORACLE 8

SVRMGR> select * from v$version; BANNER ---------------------------------------------------------------- Oracle8 Release 8.0.5.0.0 - Production PL/SQL Release 8.0.5.0.0 - Production CORE Version 4.0.5.0.0 - Production TNS for 32-bit Windows: Version 8.0.5.0.0 - Production NLSRTL Version 3.3.2.0.0 - Production 5 rows selected.

dul版本 DUL 10

e:\dul10>dul    Data UnLoader: 10.2.0.5.26 - Internal Only - on Sat Feb 15 15:54:15 2014 with 64-bit io functions    Copyright (c) 1994 2014 Bernard van Duijnen All rights reserved.     Strictly Oracle Internal Use Only       Found db_id = 1207542366 Found db_name = ORCL

DUL读取数据文件

DUL> show datafiles; ts# rf# start   blocks offs open  err file name UNK   1     0   102401    0    1    0 C:\Users\XIFENFEI\Desktop\temp\SYS1ORCL.ORA

DUL10参数配置

DUL> show parameter; _SLPE_DEBUG               = FALSE ALLOW_CHECKSUM_MISMATCH   = TRUE ALLOW_DBA_MISMATCH        = TRUE ALLOW_OTHER_OBJNO         = TRUE ALLOW_TRAILER_MISMATCH    = TRUE ASM_DO_HARD_CHECKS        = TRUE AUTO_UPDATE_CHECKSUM      = TRUE AUTO_UPDATE_TRAILER       = TRUE BUFFER                    = 10485760 CF_FILES                  = 1022 CF_TABLESPACES            = 64 COMPATIBLE                = 8 CONTROL_FILE              = control.txt DB_BLOCK_SIZE             = 2048 DB_NAME                   = DB_ID                     = 0 DC_COLUMNS                = 100000 DC_OBJECTS                = 128k DC_TABLES                 = 10000 DC_USERS                  = 1000 DC_SEGMENTS               = 10000 DC_EXTENTS                = 10000 DEFAULT_CHARACTER_SET     = DEFAULT_NATIONAL_CHARACTER_SET = EXPORT_MODE               = false FEEDBACK                  = 1000 FILE                      = FILE_SIZE_IN_MB           = 0 LDR_ENCLOSE_CHAR          = | LDR_OUTPUT_IN_UTF8        = FALSE LDR_PHYS_REC_SIZE         = 0 LOGFILE                   = dul.log MAX_OPEN_FILES            = 8 OSD_MAX_THREADS           = 1055 OSD_BIG_ENDIAN_FLAG       = false OSD_DBA_FILE_BITS         = 10 OSD_FILE_LEADER_SIZE      = 1 OSD_C_STRUCT_ALIGNMENT    = 32 OSD_WORD_SIZE             = 32 PARSE_HEX_ESCAPES         = FALSE RESET_LOGFILE             = FALSE SCAN_DATABASE_SCANS_LOB_SEGMENTS = TRUE SCAN_STEP_SIZE            = 512 TRACE_FLAGS               = 0 UNEXP_MAX_ERRORS          = 1000 UNEXP_VERBOSE             = FALSE USE_LOB_FILES             = TRUE USE_SCANNED_EXTENT_MAP    = FALSE VERIFY_NUMBER_PRECISION   = TRUE WARN_RECREATE_FILES       = TRUE WRITABLE_DATAFILES        = FALSE

郑全

DUL10加载ORACLE 8数据字典

DUL> bootstrap; Probing file = 1, block = 527   database version 8 bootstrap$ at file 1, block 352 . unloading table                BOOTSTRAP$ DUL: Warning: block number is non zero but marked deferred trying to process it anyhow       52 rows unloaded DUL: Warning: Dictionary cache DC_BOOTSTRAP is empty Reading BOOTSTRAP.dat 52 entries loaded Parsing Bootstrap$ contents DUL: Warning: Recreating file "dict.ddl" Generating dict.ddl for version 8  OBJ$: segobjno 18, file 1 block 167  TAB$: segobjno 2, tabno 1, file 1  block 52  COL$: segobjno 2, tabno 5, file 1  block 52  USER$: segobjno 10, tabno 1, file 1  block 147 Running generated file "@dict.ddl" to unload the dictionary tables . unloading table                      OBJ$    3504 rows unloaded . unloading table                      TAB$     434 rows unloaded . unloading table                      COL$   16185 rows unloaded . unloading table                     USER$      24 rows unloaded Reading USER.dat 24 entries loaded Reading OBJ.dat 3504 entries loaded and sorted 3504 entries Reading TAB.dat 434 entries loaded Reading COL.dat 16185 entries loaded and sorted 16185 entries Reading BOOTSTRAP.dat 52 entries loaded    DUL: Error: No entry in OBJ$ for "TABCOMPART$" type = 2 DUL: Error: No base dict info for SYS.TABCOMPART$ DUL: Error: No entry in OBJ$ for "INDCOMPART$" type = 2 DUL: Error: No base dict info for SYS.INDCOMPART$ DUL: Error: No entry in OBJ$ for "TABSUBPART$" type = 2 DUL: Error: No base dict info for SYS.TABSUBPART$ DUL: Error: No entry in OBJ$ for "INDSUBPART$" type = 2 DUL: Error: No base dict info for SYS.INDSUBPART$ DUL: Warning: Recreating file "dict.ddl" Generating dict.ddl for version 8  OBJ$: segobjno 18, file 1 block 167  TAB$: segobjno 2, tabno 1, file 1  block 52  COL$: segobjno 2, tabno 5, file 1  block 52  USER$: segobjno 10, tabno 1, file 1  block 147  TABPART$: segobjno 180, file 1 block 1275  INDPART$: segobjno 182, file 1 block 1285  IND$: segobjno 2, tabno 3, file 1  block 52  ICOL$: segobjno 2, tabno 4, file 1  block 52  LOB$: segobjno 2, tabno 8, file 1  block 52 Running generated file "@dict.ddl" to unload the dictionary tables . unloading table                      OBJ$ DUL: Warning: Recreating file "OBJ.ctl"     3504 rows unloaded . unloading table                      TAB$ DUL: Warning: Recreating file "TAB.ctl"      434 rows unloaded . unloading table                      COL$ DUL: Warning: Recreating file "COL.ctl"    16185 rows unloaded . unloading table                     USER$ DUL: Warning: Recreating file "USER.ctl"       24 rows unloaded . unloading table                  TABPART$       0 rows unloaded . unloading table                  INDPART$       0 rows unloaded . unloading table                      IND$     525 rows unloaded . unloading table                     ICOL$     899 rows unloaded . unloading table                      LOB$      27 rows unloaded

郑全

Reading USER.dat 24 entries loaded

Reading OBJ.dat 3504 entries loaded and sorted 3504 entries

Reading TAB.dat 434 entries loaded

Reading COL.dat 16185 entries loaded and sorted 16185 entries

Reading TABPART.dat 0 entries loaded and sorted 0 entries

Reading INDPART.dat 0 entries loaded and sorted 0 entries

Reading IND.dat 525 entries loaded

Reading LOB.dat 27 entries loaded

Reading ICOL.dat 899 entries loaded

Reading BOOTSTRAP.dat 52 entries loaded

DUL 10 unload ORACLE 8 TABLE

DUL> unload table ts$; . unloading table                       TS$       4 rows unloaded DUL>

通过测试,证明DUL10可以完美支持ORACLE 8.0数据库,在以后的低版本数据使用dul unload过程中,可以直接使用最新版本,而不用去到处寻找老版本dul