{"id":636,"date":"2015-11-06T08:34:58","date_gmt":"2015-11-06T08:34:58","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=636"},"modified":"2015-11-06T08:34:58","modified_gmt":"2015-11-06T08:34:58","slug":"data-recovery-unloader-%ec%84%a4%eb%aa%85","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=636","title":{"rendered":"Data recovery UnLoader \uc124\uba85"},"content":{"rendered":"

\n <\/p>\n

\uc774 document\ub294 version8\uc5d0 \uae30\ubc18\ud558\uc5ec upgrade\ud558\uc600\ub2e4. \ub610\ud55c \ub2e8\uc21c\uc774 dul executable\uacfc \ud568\uaed8 download\ubc1b\ub294 usg.html\uc744 \ubc88\uc5ed\ud55c \uac83\uc774 \uc544\ub2c8\ub77c \uadf8 \ub3d9\uc548 dul\uc744 \uc0ac\uc6a9\ud558\uba74\uc11c \uc313\uc544 \uc654\ub358 \uacbd\ud5d8 \ub4f1\uc744 \ud568\uaed8 \uc368\ub193\uc558\uace0 raw device dul\uc744 \uc0ac\uc6a9\ud558\ub294\ub370 \ud544\uc694\ud55c \ub0b4\uc6a9\ub3c4 \uc368\ub193\uc558\ub2e4
\n<\/span><\/p>\n

\uc774 document\uac00 site\ub97c \uc9c0\uc6d0\ud558\ub294 Engineer\uc5d0\uac8c \uc870\uae08\uc774\ub77c\ub3c4 \ub3c4\uc6c0\uc774 \ub410\uc73c\uba74 \ud558\ub294 \ubc14\ub78c\uc744 \uac00\uc9c4\ub2e4.
\n<\/span><\/p>\n

1. \uac1c\uc694
\n<\/span><\/h2>\n

\n <\/p>\n

1. Dul\uc758 \uc6d0\ub9ac\uc640 \ud2b9\uc9d5
\n<\/span><\/h3>\n
    \n
  • \uacf5\uc2dd \uc9c0\uc6d0 utility\uac00 \uc544\ub2c8\ub2e4.
    \n<\/span><\/li>\n
  • Exp, Sql*plus\uc758 \ub300\uc548\uc774 \uc544\ub2cc \uadf8\uc57c\ub9d0\ub85c \ucd5c\ud6c4\uc758 \ubcf5\uad6c \ubc29\ubc95\uc73c\ub85c \uc0ac\uc6a9<\/strong> \ub418\uc5b4 \uc838\uc57c \ud55c\ub2e4.
    \n<\/span><\/li>\n
  • Dul\uc740 \ub370\uc774\ud130 \ud30c\uc77c\uc758 \ud14c\uc774\ube14\ub85c \ubd80\ud130 row\ub97c \uc9c1\uc811 \ucd94\ucd9c\ud558\uae30 \uc704\ud55c C \ud504\ub85c\uadf8\ub7a8\uc73c\ub85c RDBMS\uc640\ub294 \uc804\ud600 \ubcc4\uac1c\ub85c \ub3d9\uc791\ud55c\ub2e4.(\u2234data file\uc774 \uc874\uc7ac\ud574\uc57c \ud55c\ub2e4<\/span>)
    \n<\/span><\/li>\n
  • Dul\uc740 \ubaa8\ub4e0 \ud2b8\ub79c\uc7ad\uc158\uc774 commit\ub418\uc5c8\ub2e4\uace0 \uac00\uc815\ud558\uace0 media recovery\ub610\ud55c \ud558\uc9c0 \uc54a\ub294\ub2e4.
    \n<\/span><\/li>\n
  • \ub370\uc774\ud0c0\ubca0\uc774\uc2a4\uac00 \uc190\uc0c1\ub418\uc5c8\ub2e4 \ud574\ub3c4 \uac01\uac01\uc758 \ub370\uc774\ud130 \ube14\ub85d\uc774 100%\uc815\ud655\ud574\uc57c \ub41c\ub2e4
    (\ub9cc\uc77c bad block\uc774 \ub098\uc624\uba74 error message\ud6c4 continue)
    \n<\/span><\/li>\n
  • Dul\uc5d0\uc11c\ub294 \ud14c\uc774\ube14\/\ud074\ub7ec\uc2a4\ud130\uc758 data\ub9cc\uc744 unload<\/span>\ud55c\ub2e4. \uc989 triggers, stored procedures, table\/view’s script\ub294 \ub9cc\ub4e4\uc9c0 \uc54a\ub294\ub2e4(\uadf8\ub7ec\ub098 \ub370\uc774\ud130 \uc0ac\uc804\uc744 unload\ud558\ubbc0\ub85c\uc11c \uadf8\uac83\ub4e4\uc5d0 \ub300\ud55c \uc815\ubcf4\ub294 \uc5bb\uc744 \uc218 \uc788\ub2e4.) \ucd94\ucd9c\ub418\ub294 \ub370\uc774\ud130\ub294 Sql*Loader \uc774\ub098 IMP\ud615\uc2dd\uc73c\ub85c \ubc1b\uc744 \uc218 \uc788\ub2e4 DUL8\uc740 indexes\ub098 Index organized tables\ub97c \ucd94\ucd9c\ud560 \uc218 \uc788\ub294\ub370 index unload\ub294 table\uc774 \uac00\uc9c0\uace0 \uc788\ub294 row\uc758 \uac1c\uc218\ub098 missing\ub41c row\uac00 \ubb34\uc5c8\uc778\uc9c0\ub97c \uacb0\uc815\ud558\ub294\ub370 \uc788\uc5b4\uc11c \uc720\uc6a9\ud55c \ub2e8\uc11c\uac00 \ub420 \uc218 \uc788\ub2e4.
    \n<\/span><\/li>\n
  • (\uac70\uc758)\ubaa8\ub4e0 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad6c\uc870\ub97c \uc9c0\uc6d0\ud574 \uc900\ub2e4.( row chaining, row migration, hash\/index clusters, longs, raws, rowids, dates, numbers, multiple free group, segment high water mark, NULLs , trailing NULL columns,unlimited extents, new block layout of oracle8, partitioned table)
    \n<\/span><\/li>\n
  • \ubaa8\ub4e0 Oracle6, Oracle7, 8.0.4\uc5d0\uc11c \ub3d9\uc791
    \n<\/span><\/li>\n
  • \n
    Multi byte\ub97c \uc9c0\uc6d0: dul command\uc5d0\uc11c multibyte\ub294 \uc0ac\uc6a9\ubd88\uac00\ub2a5\ud558\uc9c0\ub9cc multi byte database\ub294 unload\uac00\ub2a5
    \n<\/span><\/div>\n

    \n <\/p>\n<\/p>\n

    2. dul\uc758 \uc81c\ud55c\uc0ac\ud56d
    \n<\/span><\/h3>\n<\/p>\n<\/li>\n
  • Trusted Oracle\uc5d0\uc11c\ub294 \uc0ac\uc6a9\ud560 \uc218 \uc5c6\ub2e4.
    \n<\/span><\/li>\n
  • Long raw column\uc744 unload\ud560 \uc218\ub294 \uc788\uc9c0\ub9cc 1\ub3001\ub85c sql*loader\ub85c reload\ud558\ub294 \ubc29\ubc95\uc740 \uc5c6\ub2e4. \uadf8\ub7ec\ubbc0\ub85c export mode\ub85c unload\ud558\ub358\uc9c0 \ubcc4\ub3c4\uc758 Pro*c program\uc73c\ub85c data\ub97c load\ud574\uc57c \ud55c\ub2e4.
    \n<\/span><\/li>\n
  • \n
    Oracle8 object option and lobs:lobs,varrays, object, nested table\ub294 \uc544\uc9c1 \uc9c0\uc6d0\ud558\uc9c0 \uc54a\ub294\ub2e4.
    \n<\/span><\/div>\n

    \n <\/p>\n

    \n <\/p>\n<\/p>\n

    3. Dul\uc758 \uc2e4\ud589\uc808\ucc28.
    \n<\/span><\/h3>\n<\/p>\n<\/li>\n<\/ul>\n
      \n
    1. The parameter file “init.dul” is processed.
      \n<\/span><\/li>\n
    2. The DUL control file (default “control.dul”) is scanned.
      \n<\/span><\/li>\n
    3. Try to load dumps of the USER$, OBJ$, TAB$, COL$ if available into DUL’s data dictionary cache.
      \n<\/span><\/li>\n
    4. Try to load seg.dat and col.dat.
      \n<\/span><\/li>\n
    5. \n
      Accept DDL-statements or run the DDL script specified as first arg.
      \n<\/span><\/div>\n

      \n <\/p>\n<\/p>\n

      2. DUL\uc758 ddl, init.dul, control.dul
      \n<\/span><\/h2>\n<\/p>\n

      \n <\/p>\n<\/p>\n

      1. Dul\uc758 DDL.
      \n<\/span><\/h3>\n<\/p>\n

      \ub2e4\uc74c\uc740 dul\uc5d0\uc11c \uc0ac\uc6a9\uac00\ub2a5 \ud55c command \ubc0f init.dul parameter\uc5d0 \ub300\ud574\uc11c \uc54c\uc544\ubcf4\uae30\ub85c \ud55c\ub2e4.
      \n<\/span><\/p>\n<\/p>\n

      Dul\uc2e4\ud589 \uc2dc \uc0ac\uc6a9\ub418\ub294 DDL ( DUL DESCRIPTION LANGUAGE )\ubb38<\/span>
      \n\t\t\t\t\t<\/span><\/h4>\n<\/p>\n

      dul\uc744 \uc2e4\ud589\ud558\uc5ec \uc0ac\uc6a9\ub418\uc5b4\uc9c0\ub294 unload\ubb38\uc740 SQL\uacfc \ube44\uc2b7\ud558\ub2e4.
      \n<\/span><\/p>\n

      ALTER SESSION SET init.dul parameter = value ;
      \n<\/span><\/p>\n

      DESCRIBE owner_name . table_name ;
      \n<\/span><\/p>\n

      DUMP [ TABLESPACE tablespace_no ]
      \n<\/span><\/p>\n

      [ FILE file_no ]
      \n<\/span><\/p>\n

      [ BLOCK block_no ]
      \n<\/span><\/p>\n

      [ LEVEL level_no ] ;
      \n<\/span><\/p>\n

      UNLOAD DATABASE;
      \n<\/span><\/p>\n

      UNLOAD USER user_name;
      \n<\/span><\/p>\n

      UNLOAD TABLE [ schema_name . ] table_name
      \n<\/span><\/p>\n

      [ ( column_definitions ) ]
      \n<\/span><\/p>\n

      [ cluster_clause ]
      \n<\/span><\/p>\n

      [ storage_clause ] ;
      \n<\/span><\/p>\n

      UNLOAD EXTENT table_name
      \n<\/span><\/p>\n

      [ ( column_definitions ) ]
      \n<\/span><\/p>\n

      [ TABLESPACE tablespace_no ]
      \n<\/span><\/p>\n

      FILE extent_start_file_number
      \n<\/span><\/p>\n

      BLOCK extent_start_block_number
      \n<\/span><\/p>\n

      BLOCKS extent_size_in oracle_blocks
      \n<\/span><\/p>\n

      storage_clause ::=
      \n<\/span><\/p>\n

      STORAGE ( storage_specification [ more_storage_specs ] )
      \n<\/span><\/p>\n

      storage_specification ::=
      \n<\/span><\/p>\n

      OBJNO object_id_number
      \n<\/span><\/p>\n

      | TABNO cluster_table_number
      \n<\/span><\/p>\n

      | SEGOBJNO cluster\/data_object_number \/* v7\/v8 style data block id *\/
      \n<\/span><\/p>\n

      | FILE data_segment_header_file_number \/* v6 style data block id *\/
      \n<\/span><\/p>\n

      BLOCK data_segment_header_block_number )
      \n<\/span><\/p>\n

      | any_normal_storage_specification_but_silently_ignored
      \n<\/span><\/p>\n

      \n <\/p>\n

      SCAN DATABASE;
      \n<\/span><\/p>\n

      Scans all blocks of all data files.
      \n<\/span><\/p>\n

      Two files are generated:
      \n<\/span><\/p>\n

      1: seg.dat information of found segment headers (index\/cluster\/table):
      \n<\/span><\/p>\n

      (object id, file number, and block number).
      \n<\/span><\/p>\n

      2: ext.dat information of contiguous table\/cluster data blocks.
      \n<\/span><\/p>\n

      (object id(V7), file and block number of segment header (V6),
      \n<\/span><\/p>\n

      file number and block number of first block,
      \n<\/span><\/p>\n

      number of blocks, number of tables)
      \n<\/span><\/p>\n

      SCAN TABLES;
      \n<\/span><\/p>\n

      Uses seg.dat and ext.dat as input.
      \n<\/span><\/p>\n

      Scans all tables in all data segments (a header block and at least one
      \n<\/span><\/p>\n

      matching extent with at least 1 table).
      \n<\/span><\/p>\n

      SCAN EXTENTS;
      \n<\/span><\/p>\n

      Uses seg.dat and ext.dat as input.
      \n<\/span><\/p>\n

      All extents for which no corresponding segment header has been found.
      \n<\/span><\/p>\n

      (Only useful if a tablespace is not complete, or a segment header
      \n<\/span><\/p>\n

      is corrupt).
      \n<\/span><\/p>\n

      REM any_text_you_like_till_End_Of_Line : comment
      \n<\/span><\/p>\n

      NOT allowed inside ddl statements. ( To avoid a two layer lexical scan).
      \n<\/span><\/p>\n

      EXIT QUIT and EOF all cause DUL to terminate.
      \n\t\t\t\t\t\t<\/strong><\/span><\/span><\/p>\n

      \n <\/p>\n

      \n <\/p>\n<\/p>\n

      2. init.dul
      \n<\/span><\/h3>\n<\/p>\n

      \uac01 init.dul\uc758 \ub0b4\uc6a9 \uacfc \uac01 port dependent parameter\uc5d0 \ub300\ud574\uc11c \uc54c\uc544\ubcf4\uc790
      \n<\/span><\/p>\n<\/p>\n

      init.dul\uc758 parameter \uc124\uba85<\/span>
      \n\t\t\t\t\t<\/span><\/h4>\n<\/p>\n

      ALIGN_FILLER
      \n<\/span><\/p>\n

      OBSOLETE
      \n<\/span><\/p>\n


      \n\t\t\t\t\tReplaced<\/span> by OSD_C_STRUCT_ALIGNMENT
      \n<\/span><\/p>\n

      ASCII2EBCDIC
      \n<\/span><\/p>\n

      BOOLEAN
      \n<\/span><\/p>\n

      Must (var)char fields be translated from EBCDIC to ASCII. (For unloading MVS database on a ASCII host)
      \n<\/span><\/p>\n

      BIG_ENDIAN_FLAG
      \n<\/span><\/p>\n

      OBSOLETE
      \n<\/span><\/p>\n


      \n\t\t\t\t\tReplaced<\/span> by OSD_BIG_ENDIAN_FLAG
      \n<\/span><\/p>\n

      BLOCKS_TO_SKIP
      \n<\/span><\/p>\n

      OBSOLETE
      \n<\/span><\/p>\n

      BUFFER
      \n<\/span><\/p>\n

      NUMBER (bytes)
      \n<\/span><\/p>\n

      row output buffer size used in export mode only. In export mode each row is first stored in this buffer, before it is written to the
      \n<\/span><\/p>\n

      dump file.
      \n<\/span><\/p>\n

      COMPATIBLE
      \n<\/span><\/p>\n

      NUMBER
      \n<\/span><\/p>\n

      Database version , valid values are 6, 7 or 8. This parameter must be specified<\/span>
      \n\t\t\t\t<\/span><\/p>\n

      CONTROL_FILE
      \n<\/span><\/p>\n

      TEXT
      \n<\/span><\/p>\n

      Name of the DUL control file (default: “control.dul”).
      \n<\/span><\/p>\n

      DBA_FILE_BITS
      \n<\/span><\/p>\n

      OBSOLETE
      \n<\/span><\/p>\n


      \n\t\t\t\t\tReplaced<\/span> by OSD_DBA_FILE_BITS
      \n<\/span><\/p>\n

      DB_BLOCK_SIZE
      \n<\/span><\/p>\n

      NUMBER
      \n<\/span><\/p>\n

      Oracle block size in bytes (Maximal 32 K)
      \n<\/span><\/p>\n

      DB_LEADING_OFFSET
      \n<\/span><\/p>\n

      OBSOLETE
      \n<\/span><\/p>\n


      \n\t\t\t\t\tReplaced<\/span> by OSD_FILE_LEADER_SIZE
      \n<\/span><\/p>\n

      DC_COLUMNS
      \n<\/span><\/p>\n

      NUMBER
      \n<\/span><\/p>\n

      DC_OBJECTS
      \n<\/span><\/p>\n

      NUMBER
      \n<\/span><\/p>\n

      DC_TABLES
      \n<\/span><\/p>\n

      NUMBER
      \n<\/span><\/p>\n

      DC_USERS
      \n<\/span><\/p>\n

      NUMBER
      \n<\/span><\/p>\n

      Sizes of dul dictionary caches. If one of these is too low startup will fail.
      \n<\/span><\/p>\n

      EXPORT_MODE
      \n<\/span><\/p>\n

      BOOLEAN
      \n<\/span><\/p>\n

      EXPort like output mode or SQL*Loader format
      \n<\/span><\/p>\n

      FILE
      \n<\/span><\/p>\n

      TEXT
      \n<\/span><\/p>\n

      Base for (dump or data) file name generation. Use this on 8.3 DOS like file systems
      \n<\/span><\/p>\n

      LDR_ENCLOSE_CHAR
      \n<\/span><\/p>\n

      TEXT
      \n<\/span><\/p>\n

      The character to enclose fields in SQL*Loader mode.
      \n<\/span><\/p>\n

      LDR_PHYS_REC_SIZE
      \n<\/span><\/p>\n

      NUMBER
      \n<\/span><\/p>\n

      Physical record size for the generated loader datafile.
      \n<\/span><\/p>\n

      LDR_PHYS_REC_SIZE = 0 No fixed records, each record is terminated with a newline.
      \n<\/span><\/p>\n

      LDR_PHYS_REC_SIZE > 2: Fixed record size.
      \n<\/span><\/p>\n

      MAX_OPEN_FILES
      \n<\/span><\/p>\n

      Maximum # files that are concurrently kept open at the OS level.
      \n<\/span><\/p>\n

      MAX_UNLOAD_BLOCKS
      \n<\/span><\/p>\n

      OBSOLETE
      \n<\/span><\/p>\n

      OSD_BIG_ENDIAN_FLAG
      \n<\/span><\/p>\n

      Byte order in machine word. Big Endian is also known as MSB first. DUL8 sets the default according to the machine it is running
      \n<\/span><\/p>\n

      on. For an explanation why this is called Big Endian, you should read Gullivers Travels.
      \n<\/span><\/p>\n

      OSD_DBA_FILE_BITS
      \n<\/span><\/p>\n

      File Number Size in DBA in bits. Or to be more precise the size of the low order part of the file number.
      \n<\/span><\/p>\n

      OSD_FILE_LEADER_SIZE
      \n<\/span><\/p>\n

      bytes\/blocks added before the real oracle file header block
      \n<\/span><\/p>\n

      OSD_C_STRUCT_ALIGNMENT
      \n<\/span><\/p>\n

      C Structure member alignment (0,16 or 32) Must be set to 32 for most ports
      \n<\/span><\/p>\n

      OSD_WORD_SIZE
      \n<\/span><\/p>\n

      Size of a machine word always 32, except for MS\/DOS(16)
      \n<\/span><\/p>\n

      PARSE_HEX_ESCAPES
      \n<\/span><\/p>\n

      Use \\\\xhh hex escape sequences in strings while parsing. The default value is FALSE. If set to true then strange characters can be
      \n<\/span><\/p>\n

      specified using escape sequences. This feature is also for specifying multi-byte characters.
      \n<\/span><\/p>\n

      TICOM_FILLER
      \n<\/span><\/p>\n

      OBSOLETE
      \n<\/span><\/p>\n

      The new parameter is OSD_C_STRUCT_ALIGNMENT
      \n<\/span><\/p>\n

      USE_SCANNED_EXTENT_MAP
      \n<\/span><\/p>\n

      BOOLEAN
      \n<\/span><\/p>\n

      Use the scanned extent map in ext.dat in unload table. This parameter is only useful if some segment headers are missing or
      \n<\/span><\/p>\n

      incorrect.
      \n<\/span><\/p>\n<\/p>\n

      \uc774\uc911 port dependent parameters\uc5d0 \ub300\ud558\uc5ec<\/span>
      \n\t\t\t\t\t<\/span><\/h4>\n<\/p>\n

      1. osd_big_endian_flag (\uc774\uc804 big_endian_flag)
      \n<\/span><\/p>\n

      \uc774\ub294 machine words\uc758 byte order\ub97c \uc124\uc815\ud558\ub294 \uac83\uc73c\ub85c
      \n<\/span><\/p>\n

      HP, SUN, mainframes\uc740 \uc77c\ubc18\uc801\uc73c\ub85cbig endian( big_endian_flag = true)
      \n<\/span><\/p>\n

      DEC, Intel platforms \uc740little endian( big_endian_flag = false) \uc73c\ub85c \uc124\uc815\ud558\uba74 \ub41c\ub2e4.
      \n<\/span><\/p>\n

      \uc774 \uc124\uc815\uc5d0 \ud2b9\ubcc4\ud55c \ubc29\ubc95\uc740 \uc5c6\uace0 unix\uc5d0\uc11c\ub77c\uba74 \ub2e4\uc74c\uacfc \uac19\uc774 \uc0b4\ud3b4 \ubcfc \uc218 \uc788\ub2e4.
      \n<\/span><\/p>\n

      \n <\/p>\n

      echo dul | od \u2013x
      \n<\/span><\/p>\n

      \n <\/p>\n

      \ud558\uc5ec \uadf8 \uacb0\uacfc\uac00 \ub2e4\uc74c\uacfc \uac19\uc73c\uba74
      \n<\/span><\/p>\n

      \n <\/p>\n

      0000000 6475 6c0a
      \n<\/span><\/p>\n

      0000004
      \n<\/span><\/p>\n

      \uc544\ub2c8\uba74
      \n<\/span><\/p>\n

      0000000 7564 0a6c
      \n<\/span><\/p>\n

      0000004
      \n<\/span><\/p>\n

      \n <\/p>\n

      2. osd_dba_file_bits (\uc774\uc804 dba_file_bits)
      \n<\/span><\/p>\n

      data block address(dba)\ub0b4\uc758 file number\uc758 low order\ubd80\ubd84\uc758 bits\uac2f\uc218 \uc774\ub2e4
      \n<\/span><\/p>\n

      \ub2e4\uc74c\uacfc \uac19\uc740 query\ub97c \uc774\uc6a9\ud558\uc5ec \ud655\uc778\ud558\uc5ec \uc124\uc815\ud560 \uc218 \uc788\ub2e4.
      \n<\/span><\/p>\n

      \n <\/p>\n

      SQL> select dump(chartorowid(‘0.0.1’)) from dual;
      \n<\/span><\/p>\n

      Typ=69 Len=6: 8,0,0,0,0,0 -> osd_dba_filebits = 5 (SCO)
      \n<\/span><\/p>\n

      Typ=69 Len=6: 4,0,0,0,0,0 -> osd_dba_filebits = 6 (Sequent , HP)
      \n<\/span><\/p>\n

      Typ=69 Len=6: 1,0,0,0,0,0 -> osd_dba_filebits = 8 (NCR,AIX)
      \n<\/span><\/p>\n

      Typ=69 Len=6: 0,16,0,0,0,0 -> osd_dba_filebits = 12 (MVS)
      \n<\/span><\/p>\n

      Typ=69 Len=10: 0,0,0,0,0,64,0,0,0,0 osd_dba_filebits = 10 (Oracle8)
      \n<\/span><\/p>\n

      \n <\/p>\n

      3. OSD_C_STRUCT_ALIGNMENT (\uc774\uc804 ALIGN_FILLER) and TICOM_FILLER
      \n<\/span><\/p>\n

      data file header\ub0b4\uc758Structure layout\uc73c\ub85c \ub2e4\uc74c\uacfc \uac19\uc774 \uc124\uc815\ud55c\ub2e4.
      \n<\/span><\/p>\n

      0: No padding between members in a C-struct (VAX\/VMS only)
      \n<\/span><\/p>\n

      1: Structure members are member size aligned.(All others including ALPHA\/VMS)
      \n<\/span><\/p>\n

      \ub2e4\uc74c\uacfc \uac19\uc740 query\ub97c \uc774\uc6a9\ud558\uc5ec \ud655\uc778\ud558\uc5ec \uc124\uc815\ud560 \uc218 \uc788\ub2e4.
      \n<\/span><\/p>\n

      \n <\/p>\n

      SELECT *
      \n<\/span><\/p>\n

      FROM v$type_size
      \n<\/span><\/p>\n

      WHERE type IN
      \n<\/span><\/p>\n

      ( ‘KCBH’, ‘KTNO’, ‘KCBH’, ‘KTBBH’, ‘KTBIT’, ‘KDBH’, ‘KTECT’, ‘KTETB’, ‘KTSHC’) ;
      \n<\/span><\/p>\n

      \uc77c\ubc18\uc801\uc73c\ub85c \uc0ac\uc6a9\ub418\ub294osd_c_struct_alignment = 32(\uc774\uc804align_filler=1) \uc740 \ub2e4\uc74c\uacfc \uac19\uc740 \uacb0\uacfc\uac00 \ub098\uc628\ub2e4
      \n<\/span><\/p>\n

      K KTNO TABLE NUMBER IN CLUSTER 1
      \n<\/span><\/p>\n

      KCB KCBH BLOCK COMMON HEADER 20
      \n<\/span><\/p>\n

      KTB KTBIT TRANSACTION VARIABLE HEADER 24
      \n<\/span><\/p>\n

      KTB KTBBH TRANSACTION FIXED HEADER 48
      \n<\/span><\/p>\n

      KDB KDBH DATA HEADER 14
      \n<\/span><\/p>\n

      KTE KTECT EXTENT CONTROL 44
      \n<\/span><\/p>\n

      KTE KTETB EXTENT TABLE 8
      \n<\/span><\/p>\n

      KTS KTSHC SEGMENT HEADER 8
      \n<\/span><\/p>\n

      8 rows selected.
      \n<\/span><\/p>\n

      \n <\/p>\n

      VAX\/VMS, Netware\ub9cc\uc774 osd_c_struct_alignment = 0(\uc774\uc804align_filler = 0)\uc774\uace0 \ub2e4\uc74c\uacfc \uac19\uc740 \uacb0\uacfc\uac00 \ub098\uc62c \uac83\uc774\ub2e4
      \n<\/span><\/p>\n

      COMPONEN TYPE DESCRIPTION SIZE
      \n<\/span><\/p>\n

      ——– ——– ——————————– ———-
      \n<\/span><\/p>\n

      K KTNO TABLE NUMBER IN CLUSTER 1
      \n<\/span><\/p>\n

      KCB KCBH BLOCK COMMON HEADER 20
      \n<\/span><\/p>\n

      KTB KTBIT TRANSACTION VARIABLE HEADER 23
      \n<\/span><\/p>\n

      KTB KTBBH TRANSACTION FIXED HEADER 42
      \n<\/span><\/p>\n

      KDB KDBH DATA HEADER 14
      \n<\/span><\/p>\n

      KTE KTECT EXTENT CONTROL 39
      \n<\/span><\/p>\n

      KTE KTETB EXTENT TABLE 8
      \n<\/span><\/p>\n

      KTS KTSHC SEGMENT HEADER 7
      \n<\/span><\/p>\n

      8 rows selected.
      \n<\/span><\/p>\n

      \uc774\uc678\uc758 \uacb0\uacfc\uac00 \ub098\uc628\ub2e4\uba74 dul\uc5d0 \uc911\ub300\ud55c \ubcc0\ud654\uac00 \uc694\uad6c\ub420 \uac83\uc774\ub2e4.
      \n<\/span><\/p>\n

      (Email bduijnen@nl.oracle.com)
      \n<\/span><\/p>\n

      \n <\/p>\n

      4. osd_file_leader_size (\uc774\uc804dba_leading_offset)
      \n<\/span><\/p>\n

      Oracle file header \uc804\uc5d0 \uc788\ub294 blocks\/bytes\uc758 \uac2f\uc218\ub97c \ub9d0\ud55c\ub2e4.
      \n<\/span><\/p>\n

      . Unix\uc758 datafiles \uc740 \uc5ec\ubd84\uc758 leading block ( file size, block size magic number)\uc744 \uac00\uc9c4\ub2e4
      \n<\/span><\/p>\n

      (100\uc774\uc0c1\uc758 \uc218\ub77c\uba74 byte offset\uc744 \ub098\ud0c0\ub0b8 \uac83\uc774\uace0 \uc791\uc740 \uc218\ub77c\uba74 oracle blocks\uc758 \uc218\ub85c \uc0dd\uac01\ud558\uba74 \ub41c\ub2e4.)
      \n<\/span><\/p>\n

      \n <\/p>\n

      Unix : dba_leading_offset = 1
      \n<\/span><\/p>\n

      Vms : dba_leading_offset = 0
      \n<\/span><\/p>\n

      Desktop : dba_leading_offset = 512
      \n<\/span><\/p>\n

      Others : Unknown ( Use Andre Bakker’s famous PATCH utility to find out)
      \n<\/span><\/p>\n

      Oracle file header block\uc740 0X0B010000 pattern\uc73c\ub85c \uc2dc\uc791\ub41c\ub2e4
      \n<\/span><\/p>\n

      \uc5ec\ubd84\uc758 byte offset \uc744control.dul\uc758 3\ubc88\uc9f8 \uc778\uc790(optional)\uc5d0 \ucd94\uac00\ud560 \uc218 \uc788\ub2e4
      \n<\/span><\/p>\n

      (\uc608. AIX or DEC UNIX data files on raw device)
      \n<\/span><\/p>\n

      \n <\/p>\n

      5.dc_columns, dc_objects, dc_tables, dc_users\ub294 dul\uc774 data dictionary cash\ub85c\uc11c \uc2e4\uc81c db\ub0b4\uc5d0 \uc800\uc7a5\ub41c \uac2f\uc218 \ubcf4\ub2e4\ub294 \ud06c\ub3c4\ub85d \ucda9\ubd84\ud55c \uac12\uc744 \uc8fc\uc5b4 \uc124\uc815\ud55c\ub2e4.
      \n<\/span><\/p>\n

      \n <\/p>\n

      6.db_block_size : DB\uc758 block size\ub97c \uc4f4\ub2e4(ex 2048)
      \n<\/span><\/p>\n

      \n <\/p>\n

      7.ldr_phys_rec_size: \ud558\ub098\uc758 row size\ub97c \uc815\uc758\ud558\ub294 \uac83\uc73c\ub85c DB\uc758 \ucd5c\ub300 row\uae38\uc774\ubcf4\ub2e4\ub294 \ucda9\ubd84\ud788 \ud06c\uac8c \uc7a1\ub294\ub2e4.
      \n<\/span><\/p>\n

      \u261edul\ub85c \ub370\uc774\ud130\ub97c sql*loader mode\ub85c \ub0b4\ub838\uc744 \uacbd\uc6b0 \ud06c\uac8c 2\uac00\uc9c0 mode\ub85c \ub0b4\ub824\uc624\uac8c \ub418\ub294\ub370
      \n<\/span><\/p>\n

      \uccab\uc9f8\ub294 stream mode\ub85c ldr_phys_rec_size=0\uc73c\ub85c setting\ud588\uc744 \uacbd\uc6b0\uc5d0 \ud574\ub2f9\ud55c\ub2e4.
      \n<\/span><\/p>\n

      \uadf8\ub7f0\ub370 \uc774 mode\ub85c dul\uc744 \uc4f4\ub2e4\ub294 \uac83\uc740 user\uc758 \ub370\uc774\ud130 \uc911\uc5d0 newling character\uac00 \ub4e4\uc5b4 \uc788\uc9c0
      \n<\/span><\/p>\n

      \uc54a\ub2e4\ub294 \uc804\uc81c\ud558\uc5d0\uc11c \uc368\uc57c \ud55c\ub2e4. \uc774\uc804\uc5d0 dul\ub85c recovery \ud560\ub54c \uc720\uc800\uc758 \ud504\ub85c\uadf8\ub7a8\uc774 \ud30c\uc6cc\ube4c\ub354
      \n<\/span><\/p>\n

      \uc600\uc5c8\ub294\ub370operator\uac00 \ud2b9\uc815 text field\uc5d0\uc11c retune key\ub97c \uce58\uae30\ub3c4 \ud558\ub294 \uad00\uacc4\ub85c \uc774 mode\ub85c \ub0b4\ub9b0
      \n<\/span><\/p>\n

      sam file\uc744 load\ud560\ub54c \uc560\ub97c \uba39\uc740 \uacbd\uc6b0\uac00 \uc788\uc5c8\ub2e4.
      \n<\/span><\/p>\n

      \uc774 \uacbd\uc6b0 Fixed Physical Records mode\ub85c \ub0b4\ub838\uc744 \uacbd\uc6b0 \uc190 \uc27d\uac8c \ud560 \uc218 \uc788\uc744 \uac83\uc774\ub2e4
      \n<\/span><\/p>\n

      Fiexed Physical Record mode\ub294 ldr_phys_rec_size\uc5d0 size\ub97c \uc8fc\uba74 \uc124\uc815\ub418\uba74 default\ub294 81\uc774\ub2e4.
      \n<\/span><\/p>\n

      \n <\/p>\n

      8.LDR_ENCLOSE_CHAR
      \n<\/span><\/p>\n

      \u261edul\uc774 Sql*loader format\uc73c\ub85c \ub0b4\ub9b4\ub54c \uac01\uac01\uc758 column\uc744 \ubd84\ub9ac\ud558\ub294 \ubd84\ub9ac\uc790\ub85c \ud754\ud788 double quotes\uac00 \uc4f0\uc778\ub2e4. \uadf8\ub7f0\ub370 user\uc758 data\uc911\uc5d0 double quotes\uac00 \uc788\uc744 \uacbd\uc6b0 \ud63c\ub3c8 \ub418\ubbc0\ub85c \uc774\ub7f4 \uacbd\uc6b0\uc5d0\ub294 \ub2e4\ub978 \ubb38\uc790\ub85c \ubd84\ub9ac\uc790\ub97c \uc9c0\uc815\ud574\uc57c \ud55c\ub2e4<\/span>.
      \n<\/span><\/p>\n

      \n <\/p>\n<\/p>\n

      Platform specific parameter \uc815\ub9ac
      \n<\/span><\/h4>\n<\/p>\n

      In this page I will try to collect all init.dul parameters for all
      \n<\/span><\/p>\n

      platforms. Additions and corrections are welcome!
      \n<\/span><\/p>\n

      \n <\/p>\n

      PORT PLATFORM ENDIAN FBITS67 FBITS8 CSTR LEAD WORD
      \n<\/span><\/p>\n

      1 Digital VAX OpenVMS FALSE 8 – 0 0 32
      \n<\/span><\/p>\n

      2 HP Series 9000 HP-UX TRUE 6 10 32 1 32
      \n<\/span><\/p>\n

      21 Novell Netware FALSE 8 – 0 1 32
      \n<\/span><\/p>\n

      22 MS DOS FALSE 8 – 16 512 16
      \n<\/span><\/p>\n

      46 LINUX     FALSE – 10 32 1 32
      \n<\/span><\/p>\n

      168 Silicon Graphics UNIX TRUE 6 ? 32 1 32
      \n<\/span><\/p>\n

      172 Solaris Intel FALSE 5 ? 32 1 32
      \n<\/span><\/p>\n

      198 Sequent Dynix\/PTX FALSE 6 ? 32 1 32
      \n<\/span><\/p>\n

      319 IBM RS 600 AIX TRUE 8 ? 32 1 32
      \n<\/span><\/p>\n

      358 NCR intel FALSE 8 ? 32 1 32
      \n<\/span><\/p>\n

      453 Sun Sparc Solaris TRUE 6 10 32 1 32
      \n<\/span><\/p>\n

      912 MS Windows NT Intel FALSE 8 10 32 1 32
      \n<\/span><\/p>\n

      \n <\/p>\n

      \n <\/p>\n

      \n <\/p>\n

      \n <\/p>\n

      \n <\/p>\n

      \n <\/p>\n

      Explanation of the values:
      \n<\/span><\/p>\n

      \n <\/p>\n

      TITLE DESCRIPTION
      \n<\/span><\/p>\n

      ENDIAN OSD_BIG_ENDIAN_FLAG
      \n<\/span><\/p>\n

      FBITS67 OSD_DBA_FILE_BITS (Oracle version6\/Oracle7)
      \n<\/span><\/p>\n

      FBITS8 OSD_DBA_FILE_BITS (Oracle8)
      \n<\/span><\/p>\n

      CSTR OSD_C_STRUCT_ALIGNMENT
      \n<\/span><\/p>\n

      LEAD OSD_FILE_LEADER_SIZE
      \n<\/span><\/p>\n

      WORD OSD_WORD_SIZE
      \n<\/span><\/p>\n

      \n <\/p>\n<\/p>\n

      Sample init.dul
      \n<\/span><\/h4>\n<\/p>\n

      \n <\/p>\n

      # sample init.dul configuration parameters
      \n<\/span><\/p>\n

      # these must be big enough for the database in question
      \n<\/span><\/p>\n

      # the cache must hold all entries from the dollar tables.
      \n<\/span><\/p>\n

      dc_columns = 200000
      \n<\/span><\/p>\n

      dc_tables = 10000
      \n<\/span><\/p>\n

      dc_objects = 10000
      \n<\/span><\/p>\n

      dc_users = 40
      \n<\/span><\/p>\n

      \n <\/p>\n

      # OS specific parameters
      \n<\/span><\/p>\n

      osd_big_endian_flag = false
      \n<\/span><\/p>\n

      osd_dba_file_bits = 6
      \n<\/span><\/p>\n

      osd_c_struct_alignment = 32
      \n<\/span><\/p>\n

      osd_file_leader_size = 1
      \n<\/span><\/p>\n

      \n <\/p>\n

      # database parameters
      \n<\/span><\/p>\n

      db_block_size = 2048
      \n<\/span><\/p>\n

      \n <\/p>\n

      # loader format definitions
      \n<\/span><\/p>\n

      LDR_ENCLOSE_CHAR = ”
      \n<\/span><\/p>\n

      LDR_PHYS_REC_SIZE = 81<\/span>
      \n\t\t\t\t\t<\/span><\/span><\/p>\n

      2.
      \n<\/span><\/p>\n<\/p>\n

      3.Control.dul
      \n<\/span><\/h3>\n<\/p>\n

      Control file \uc758 \uc791\uc131<\/span>
      \n\t\t\t\t\t<\/span><\/h4>\n<\/p>\n

      control file (default name “control.dul”)\uc740 file numbers\ub97c file\uc774\ub984\uc73c\ub85c \ubc14\uafb8\ub294\ub370 \uc0ac\uc6a9\ub41c\ub2e4
      \n<\/span><\/p>\n

      dul V8\ubd80\ud130 \uadf8 \ud615\uc2dd\uc774 \ud655\uc7a5\ubcc0\ud654 \ub418\uc5c8\ub2e4.
      \n<\/span><\/p>\n

      if COMPATIBLE is 6 or 7:
      \n<\/span><\/p>\n

      control_file_line_for_6_or_7 ::=
      \n<\/span><\/p>\n

      file_number data_file_name
      \n<\/span><\/p>\n

      [ optional extra leader offset ]
      \n<\/span><\/p>\n

      [ startblock block_no ]
      \n<\/span><\/p>\n

      [ endblock block_no ]
      \n<\/span><\/p>\n

      If COMPATIBLE is 8:
      \n<\/span><\/p>\n

      control_file_line_for_8 ::=
      \n<\/span><\/p>\n

      tablespace_no relative_file_number data_file_name
      \n<\/span><\/p>\n

      [ optional extra leader offset ]
      \n<\/span><\/p>\n

      [ startblock block_no ]
      \n<\/span><\/p>\n

      [ endblock block_no ]
      \n<\/span><\/p>\n

      \n <\/p>\n

      \u261e\uc774\uc804\uc5d0 2Giga\uc774\uc0c1\uc758 unload file\uc774 \uc0dd\uc131\ub418\ub294 \uac83\uc744 \ub9c9\uac70\ub098, dul\uc744 \uc368\uc11c Unload\ud55c data\ub97c load\ud560\ub54c \uc6d0\uc778 \ubd88\uba85\uc758 \uc0ac\uc720\ub85c sql*loader\uac00 \ud2b9\uc815 row#\uc5d0 \uac00\uba74 \uc8fd\uc5b4\uc11c \uc774\ud6c4\uc5d0 unload\ud55c data\uc870\ucc28 \uc9d1\uc5b4 \ub123\uc9c0 \ubabb\ud558\uac8c \ud55c\uc801\uc774 \uc788\uc2b5\ub2c8\ub2e4<\/strong>. \uadf8\ub54c\ub294 init.dul\uc5d0 blocks_to_skip, max_unload_blocks\ub77c\ub294 parameter(dul v8\uc5d0\uc11c\ubd80\ud130\ub294 obsolete\ub428)\ub97c \uc774\uc6a9\ud558\uc5ec block\uc744 \ub098\ub204\uc5b4 \ubc1b\uc544 \ubb38\uc81c\ub418\ub294 block \uc744 skip\ud55c \uc801\uc774 \uc788\uc5c8\ub294\ub370 \uc774 parameter\uac00 \uc774\uc81c\ub294 control.dul\ub85c \uc62e\uaca8\uc628 \uac83 \uac19\uc2b5\ub2c8\ub2e4. \uc9c1\uad00\uc801\uc73c\ub85c \uc0dd\uac01\ud574\ub3c4 \uc774\uac83\uc774 \ub354\uc6b1 \ub9de\ub294 \uac83 \uac19\uc2b5\ub2c8\ub2e4. \uc5ec\ud558\ud2bc startblock block_no, endblock block_no option\uc744 \uc774\uc6a9\ud558\uc5ec \uc704\uc640 \ub3d9\uc77c\ud55c \ubb38\uc81c\uc5d0 \uc801\uc6a9 \uac00\ub2a5\ud560 \uac83 \uac19\uc2b5\ub2c8\ub2e4.
      \n<\/span><\/p>\n

      \n <\/p>\n

      \uac01file number\uc640 file name(oracle 8\uc5d0\uc11c\ub294 tablespace)\uc744 \ud589\uc73c\ub85c \ubd84\ub9ac\ud558\uc5ec \uc9c0\uc815\ud558\uba74 \ub41c\ub2e4.
      \n<\/span><\/p>\n

      \uc138 \ubc88\uc9f8 \ud544\ub4dc(optional)\ub294 \uc591\/\uc74c\uc218\ub85c \uc9c0\uc815\ud558\uc5ec byte offset\uc744 \ub098\ud0c0 \ub0b4\ub294\ub370(\uc9c0\uc815\ub41c data file\uc5d0 lseek()\uc5f0\uc0b0\uc744 \uc218\ud589 \uc2dc\ud0b4) AIX\uc758 raw devices\ub97c \uac74\ub108 \ub6f0\uac70\ub098 \ub370\uc774\ud130\ud654\uc77c\uc758 \uc870\uac01\uc744 unload \ud560 \ub54c \uc4f0\uc778\ub2e4.
      \n<\/span><\/p>\n

      \u261eAIX, DEC\uc758 Raw device\uc758 \uacbd\uc6b0 optional option\uc744 \uc0ac\uc6a9\ud574\uc57c \ud55c\ub2e4<\/strong>.
      \n<\/span><\/p>\n

      AIX:IBM AIX\uc758 \uacbd\uc6b0 \uac01\uac01\uc758 logical volumn\uc5d0\ub294 control block[LVCB]\uc774\ub77c\ub294 \uac83\uc774 \uc788\uc73c\uba70 \uc774\uac83\uc740 \uac01\uac01\uc758 logical volumn\uc758 \uccab\ubc88\uc9f8 bock\uc5d0 \uc704\uce58\ud558\uc5ec control information\uc744 \uc800\uc7a5\ud55c\ub2e4(\uc989 logical volumn data\ub294 second 512-byte block\ub4a4\uc5d0\uc11c \ubd80\ud130 \uc2dc\uc791\ud558\ub294 \uc148). \uadf8\ub7f0\ub370 \uc2e4\uc81c\ub85c oracle\uc758 \uc2e4 datafile\uc740 \uc774 LVCB(control block) \ubc14\ub85c \ub2e4\uc74c\uc5d0 \uc704\uce58 \ud558\ub294 \uac83\uc774 \uc544\ub2c8\ub77c AIX\uc758 alignment issue \ub4f1\uc744 \uace0\ub824\ud558\uc5ec \uc2e4\uc81c\ub85c\ub294 Second 4K(4096) block\uc5d0 \uc704\uce58\ud55c\ub2e4. \uadf8\ub7ec\ubbc0\ub85c dul\ub85c raw device\ub85c \uc774\ub8e8\uc5b4\uc9c4 AIX\uc758 Datafile\uc744 \ub044\uc9d1\uc5b4 \ub0b4\uae30 \uc704\ud574\uc11c\ub294 OS\uc758 4096 byptes\uc744 Skip\ud574\uc57c \ud55c\ub2e4.
      \n<\/span><\/p>\n

      Digital Unix: Digital Unix\uc758 \uacbd\uc6b0 \uac01\uac01\uc758 raw device\uc758 \uc2dc\uc791\ubd80\ubd84\uc5d0 64K Operating System Header\ub97c \uc0ac\uc6a9\ud55c\ub2e4 \uadf8\ub7ec\ubbc0\ub85c Dul\ub85c digital unix raw device\uc758 datafile\uc744 \ub044\uc9d1\uc5b4 \ub0b4\uae30 \uc704\ud574\uc11c\ub294 65536(64K)\ub9cc\ud07c\uc744 skip\ud574\uc57c \ud55c\ub2e4.
      \n<\/span><\/p>\n

      \uc774\uac83\uc744 \ud558\uc9c0 \uc54a\uc558\uc744 \uacbd\uc6b0 \ub2e4\uc74c\uacfc \uac19\uc740 error\ub97c \ub9cc\ub0a0 \uac83\uc774\ub2e4.
      \n<\/span><\/p>\n

      UnLoader: Release 2.2.0.2 – Very Restricted on Fri Feb 14 20:29:20 1997
      \n<\/span><\/p>\n

      Copyright (c) 1994\/95 Oracle Corporation, The Netherlands. All rights reserved.
      \n<\/span><\/p>\n

      DUL: Warning: BDU-600[illegal block version]
      \n<\/span><\/p>\n

      DUL: Warning: BDU-600[illegal block version]
      \n<\/span><\/p>\n

      DUL: Warning: Block[1][194] DBA in block different [1][162]
      \n<\/span><\/p>\n

      DUL: Warning: Open of cursor for table failed
      \n<\/span><\/p>\n

      DUL: Warning: BDU-600[illegal block version]
      \n<\/span><\/p>\n

      DUL: Warning: BDU-600[illegal block version]
      \n<\/span><\/p>\n

      DUL: Warning: Block[1][84] DBA in block different [1][52]
      \n<\/span><\/p>\n

      DUL: Warning: Open of cursor for table failed
      \n<\/span><\/p>\n

      DUL: Warning: Block[1][84] DBA in block different [1][52]
      \n<\/span><\/p>\n

      DUL: Warning: Open of cursor for table failed
      \n<\/span><\/p>\n

      \u261e\uac00\ub054 user\uc758 \uc2e4\uc218\ub85c drop, delete\ub41c table\uc5d0 \ub300\ud574 \uae30\uc874\uc758 datafile\uc744 \uc774\uc6a9\ud574\uc11c \uc774\ub97c \ubcf5\uad6c\ud560 \uacbd\uc6b0<\/strong>\uac00 \uc788\ub294\ub370 \uc774\ub54c\ub294 \uad73\uc774 \ubaa8\ub4e0 datafile\uc744 unload\ud560 \ud544\uc694 \uc5c6\uc774 system tablespace datafile\uacfc \uad00\ub828\ub41c tablespace datafile\ub9cc \ub0b4\ub9b0\ub2e4. \ud2b9\ud788 tape\uc5d0\uc11c \ub0b4\ub9b4 \ub54c \ub611\uac19\uc740 directory\ub85c \ub0b4\ub824 \uc6b4\uc601\uc911\uc778 datafile\uc744 \ub36e\uc5b4\uc4f0\ub294 \ubd88\uc0c1\uc0ac\ub294 \ubc18\ub4dc\uc2dc \ud53c\ud574\uc57c \ud55c\ub2e4. \uc784\uc758\uc758 directory\ub85c \ub0b4\ub838\uc744 \uacbd\uc6b0
      \n<\/span><\/p>\n

      control.dul file\uc5d0\uc11c \uad00\ub828 datafile\uc758 directory\uc704\uce58\ub97c modify\ud55c \ud6c4 unload\uc791\uc5c5\uc744 \uc9c4\ud589\ud55c\ub2e4.
      \n<\/span><\/p>\n

      \uc608)
      \n<\/span><\/p>\n

      # AIX version 7 example with one file on raw device
      \n<\/span><\/p>\n

      1 \/usr\/oracle\/dbs\/system.dbf 4096
      \n<\/span><\/p>\n

      8 \/dev\/rdsk\/data.dbf 4096
      \n<\/span><\/p>\n

      #Degital Unix example on raw device control.dul ##
      \n<\/span><\/p>\n

      1 \/dev\/rdrd\/drd54 65536(default 2048)
      \n<\/span><\/p>\n

      2 \/dev\/rdrd\/drd47 65536
      \n<\/span><\/p>\n

      # Oracle8 example with a datafile split in multiple parts, each part smaller than 2GB
      \n<\/span><\/p>\n

      #Oracle8\uc5d0\uc11c\ub294 tablespace number , relative file number\ub97c \ubc18\ub4dc\uc2dc \ud3ec\ud568\ud574\uc57c \ud55c\ub2e4.
      \n<\/span><\/p>\n

      0 1 \/fs1\/oradata\/PMS\/system.dbf
      \n<\/span><\/p>\n

      1 2 \/tmp\/huge_file_part1 startblock 1 endblock 1000000
      \n<\/span><\/p>\n

      1 2 \/tmp\/huge_file_part2 startblock 1000001 endblock 2000000
      \n<\/span><\/p>\n

      1 2 \/mnt3\/huge_file_part3 startblock 2000001 endblock 2550000
      \n<\/span><\/p>\n

      \n <\/p>\n<\/p>\n

      4.DUL\uc5d0\uc11c \ub370\uc774\ud130 \uc0ac\uc804(data dictionary)\uc774 \uc0ac\uc6a9 \uac00\ub2a5\ud560 \uacbd\uc6b0\uc758 \uc0ac\uc6a9 \uc608
      \n<\/span><\/h3>\n<\/p>\n

      1.init.dul\uc0dd\uc131
      \n<\/span><\/p>\n

      2.control.dul \uc0dd\uc131
      \n<\/span><\/p>\n

      sqldba
      \n<\/span><\/p>\n

      connect internal
      \n<\/span><\/p>\n

      startup mount
      \n<\/span><\/p>\n

      spool control.dul
      \n<\/span><\/p>\n

      select * from v$dbfile; (Oracle 8\uc5d0\uc11c\ub294: select ts#, rfile#, name from v$datafile;)
      \n<\/span><\/p>\n

      exit
      \n<\/span><\/p>\n

      \uacb0\uacfc\uc5d0\uc11c file number\uc640 file\uc774\ub984\ub9cc \ub0a8\uae30\uace0 \uc0ad\uc81c
      \n<\/span><\/p>\n

      3.data\ub97c unload\ud558\uae30 \uc704\ud55c dictionary cache\uc815\ubcf4\uc778 user$,obj$,tab$,col$ \uc815\ubcf4 dump
      \n<\/span><\/p>\n

      $ dul dictv7.ddl
      \n<\/span><\/p>\n

      UnLoader: Version 2.0.0.0 – Very Restricted on Tue May 16 11:04:12 1995
      \n<\/span><\/p>\n

      Copyright(c) 1994\/95 Oracle Corporation, The Netherlands. All rights reserved.
      \n<\/span><\/p>\n

      . unloading table OBJ$ 1487 rows unloaded
      \n<\/span><\/p>\n

      . unloading table TAB$ 197 rows unloaded
      \n<\/span><\/p>\n

      . unloading table COL$ 5566 rows unloaded
      \n<\/span><\/p>\n

      . unloading table USER$ 13 rows unloaded
      \n<\/span><\/p>\n

      4.dul\uc758 \uc7ac \uc2e4\ud589 \ubc0f \ud544\uc694\ud55c data unload(table, user, db\ub2e8\uc704\ub85c \uac00\ub2a5)
      \n<\/span><\/p>\n

      UnLoader: Version 2.0.0.0 – Very Restricted on Tue May 16 11:05:00 1995
      \n<\/span><\/p>\n

      Copyright(c) 1994\/95 Oracle Corporation, The Netherlands. All rights reserved.
      \n<\/span><\/p>\n

      Loaded 1487 objects
      \n<\/span><\/p>\n

      Loaded 197 tables
      \n<\/span><\/p>\n

      Loaded 5566 columns
      \n<\/span><\/p>\n

      Loaded 13 users
      \n<\/span><\/p>\n

      DUL> unload table scott.emp;
      \n<\/span><\/p>\n

      About to unload SCOTT’s tables …
      \n<\/span><\/p>\n

      . unloading table EMP 14 rows unloaded
      \n<\/span><\/p>\n

      \n <\/p>\n<\/p>\n

      5.Export mode\ub85c unload\ud558\ub294 \ubc29\ubc95
      \n<\/span><\/h3>\n<\/p>\n

      Export mode\ub85c\uc758 Unload\ub294 dul v3, dul8\uc5d0\uc11c \uc0ac\uc6a9\uac00\ub2a5\ud558\uba70 \uc774\ub97c \uc0ac\uc6a9\ud558\uae30 \uc704\ud574\uc11c\ub294 init.dul\uc5d0 EXPORT_MODE=TRUE\ub85c Setting\ud574\uc57c \ud55c\ub2e4.
      \n<\/span><\/p>\n

      \uc774\ub807\uac8c \ud55c \ud6c4 \uac01\uac01\uc758 table\ub4e4\uc740 import\uac00\ub2a5\ud55c dump file\ub85c \ub9cc\ub4e4\uc5b4 \uc9c0\ub294\ub370 \uc0ac\uc2e4 \uc774 dump File\uc740 oracle utility\uc778 Export\uc640\ub294 \uadf8 \ub0b4\uc6a9\uc774 \ub2e4\ub974\ub2e4, \uc989 oracle utility\uc778 export\ub294 \ud574\ub2f9 table\uc5d0 \ub300\ud55c grants, storage\uc808, trigger\ub97c \ud3ec\ud568\ud558\ub294 dump file\uc744 \ub9cc\ub4dc\ub294 \ubc18\uba74 dul\uc5d0 \uc758\ud55c dump file\uc740 table\uc5d0 insert\ud558\ub294 \ubb38\uc7a5\ub9cc\uc744 \uac00\uc9c0\uac8c \ub41c\ub2e4.
      \n<\/span><\/p>\n

      \uc5ec\uae30\uc5d0 create table statement\uac00 \ucd94\uac00\ub41c dump file\uc744 \uc0dd\uc131\ud560 \uc218 \uc788\ub294\ub370 \uc774\ub97c \uc704\ud574\uc11c\ub294 init.dul\uc5d0 COMPATIBLE parameter\ub97c 6 \ub610\ub294 7\ub85c \ud558\uba74 \ub41c\ub2e4.
      \n<\/span><\/p>\n

      \uc774\ub807\uac8c \ud574\uc11c \ub9cc\ub4e4\uc5b4\uc9c4 dump file\uc758 header\ub294 V6 style\uc774\uba70 \uc774\ub294 ASCII based characterset\uc784\uc744 \uc758\ubbf8\ud55c\ub2e4.
      \n<\/span><\/p>\n

      Dump file\uc744 \uc774\uc6a9\ud55c import\ub97c \ud558\uae30 \uc704\ud574\uc11c\ub294 \uc138\uc2ec\ud55c \uc8fc\uc758\ub97c \ud544\uc694\ub85c \ud558\ub294\ub370 dul\uc740 unload \ud55c row\ub97c dump file\uc5d0 \uc4f0\uae30 \uc804\uc5d0 \uba3c\uc800 \uac01\uac01\uc758 buffering\ud558\ub2e4\uac00 \uc644\uc131\ub41c row\ub9cc dump file\uc5d0 \uc4f0\uac8c \ub418\ub294\ub370 init.dul\uc758 BUFFER parameter\ub97c \uc791\uac8c \uc7a1\uc544 buffer\uac00 \uc791\uc744 \uacbd\uc6b0 \uc628\uc804\ud558\uc9c0 \ubabb\ud55c row\ub97c \ub9cc\ub4e4\uac8c \ub418\uace0 \uc774 \uacbd\uc6b0 \ud574\ub2f9 row\ub97c dump\ud30c\uc77c \uc4f0\uc9c0\uc54a\uac8c \ub418\ubbc0\ub85c buffer\ub9cc \ucef8\uc73c\uba74 unload\uac00\ub2a5 \ud588\ub358 data\uac00 \uc190\uc2e4\ub420 \uc218\ub3c4 \uc788\ub2e4\ub294 \uc810\uc774\ub2e4, \uadf8\ub7ec\ubbc0\ub85c BUFFER parameter\ub294 \ucda9\ubd84\uc774 \ud06c\uac8c \uc7a1\uc544 \uc774\ub7ec\ud55c \uc77c\uc744 \ubc29\uc9c0 \ud574\uc57c \ud55c\ub2e4.
      \n<\/span><\/p>\n

      \uc815\ub9ac\ud558\uba74 export format\uc73c\ub85c \ubc1b\uae30 \uc704\ud574\uc11c\ub294 init.dul\uc5d0 \ub2e4\uc74c parameter \ucd94\uac00
      \n<\/span><\/p>\n

      export_mode = true
      \n<\/span><\/p>\n

      compatible=7
      \n<\/span><\/p>\n

      \uc774\ub807\uac8c \ud55c \ud6c4 load\ud558\uba74 \ub428\ub2c8\ub2e4.
      \n<\/span><\/p>\n

      \uc608) imp scott\/tiger file=SCOTT_TEST_DUL.dmp full=y
      \n<\/span><\/p>\n

      \n <\/p>\n

      \n <\/p>\n<\/p>\n

      6.DUL\uc5d0\uc11c \ub370\uc774\ud130 \uc0ac\uc804(data dictionary)\uc774 \uc0ac\uc6a9 \ubd88\uac00\ub2a5\ud560 \uacbd\uc6b0\uc758 \uc0ac\uc6a9 \uc608
      \n<\/span><\/h3>\n<\/p>\n

      1.init.dul\uc0dd\uc131
      \n<\/span><\/p>\n

      2.control.dul \uc0dd\uc131
      \n<\/span><\/p>\n

      3.scan the database for segment headers and extents:
      \n<\/span><\/p>\n

      $ dul
      \n<\/span><\/p>\n

      UnLoader: Version 2.0.0.0 – Very Restricted on Tue May 16 11:10:16 1995
      \n<\/span><\/p>\n

      Copyright (c) 1994\/95 Oracle Corporation, The Netherlands. All rights reserved.
      \n<\/span><\/p>\n

      DUL> scan database;
      \n<\/span><\/p>\n

      data file 1 20480 blocks scanned
      \n<\/span><\/p>\n

      data file 4 7680 blocks scanned
      \n<\/span><\/p>\n

      data file 5 512 blocks scanned
      \n<\/span><\/p>\n

      DUL>quit => EXT.dat\uc640 SEG.dat\uac00 \uc0dd\uae34\ub2e4.
      \n<\/span><\/p>\n

      4. DUL\uc744 \uc7ac\uc2e4\ud589 \uc2dc\ud0a4\uace0 scan\ub54c \ubc1c\uacac\ub41c segment header\uc640 extent\uc815\ubcf4\ub97c \uc774\uc6a9\ud574 column\uacfc tables\uc758 \uc815\ubcf4\ub97c \ucd94\ucd9c\ud558\ub294\ub370 \uc774 \uacfc\uc815\uc5d0\uc11c \ud070 \ud654\uc77c\uc774 \ud558\ub098 \uc0dd\uae30\ubbc0\ub85c \ucda9\ubd84\ud55c disk\uc6a9\ub7c9\uc774 \uc788\uc5b4\uc57c \ud55c\ub2e4.
      \n<\/span><\/p>\n

      echo scan tables \\; | dul > scan.out&
      \n<\/span><\/p>\n

      [\uacb0\uacfc(output)]
      \n<\/span><\/p>\n

      [ many lines here]
      \n<\/span><\/p>\n

      Object id 1601 table number 0
      \n<\/span><\/p>\n

      UNLOAD TABLE T1601_0 ( C1 NUMBER, C2 UNKNOWN, C3 UNKNOWN,
      \n<\/span><\/p>\n

      C4 NUMBER, C5 DATE , C6 NUMBER, C7 NUMBER, C8 NUMBER )
      \n<\/span><\/p>\n

      STORAGE ( TABNO 0 EXTENTS( FILE 1 BLOCK 10530));
      \n<\/span><\/p>\n

      Colno Seen MaxIntSz Null% C75% C100 Num% NiNu% Dat% Rid%
      \n<\/span><\/p>\n

      1 14 3 0% 0% 0% 100% 100% 0% 0%
      \n<\/span><\/p>\n

      2 14 6 0% 100% 100% 100% 14% 0% 21%
      \n<\/span><\/p>\n

      3 14 9 0% 100% 100% 100% 14% 0% 0%
      \n<\/span><\/p>\n

      4 14 3 7% 0% 0% 100% 100% 0% 0%
      \n<\/span><\/p>\n

      5 14 7 0% 0% 0% 0% 0% 100% 0%
      \n<\/span><\/p>\n

      6 14 3 0% 0% 0% 100% 100% 0% 0%
      \n<\/span><\/p>\n

      7 14 2 71% 0% 0% 100% 100% 0% 0%
      \n<\/span><\/p>\n

      8 14 2 0% 0% 0% 100% 100% 0% 0%
      \n<\/span><\/p>\n

      “7369” “SMITH” “CLERK” “7902” “17-DEC-1980 AD 00:00:00” “800” “” “20”
      \n<\/span><\/p>\n

      “7521” “WARD” “SALESMAN” “7698” “22-FEB-1981 AD 00:00:00” “1250” “500” “30”
      \n<\/span><\/p>\n

      “7566” “JONES” “MANAGER” “7839” “02-APR-1981 AD 00:00:00” “2975” “” “20”
      \n<\/span><\/p>\n

      [ many more lines here ]
      \n<\/span><\/p>\n

      [\uacb0\uacfc\ubd84\uc11d]
      \n<\/span><\/p>\n

      \uc704\uc758 \uacb0\uacfc\uc5d0\uc11c T1601_0\uc740 table\uc758 object id\ub97c \uc774\uc6a9\ud558\uc5ec \uc784\uc2dc\ub85c \ub9cc\ub4e0 table\uba85\uc73c\ub85c \uc774\ub294 system table space\uac00 \uc190\uc0c1\ub418\uc5b4 data dictionary\uc815\ubcf4\ub97c \uac00\uc838\uc624\uc9c0 \ubabb\ud55c \uc0c1\ud0dc\uc5d0\uc11c dul\uc744 \uc0ac\uc6a9\ud558\uc600\uae30 \ub54c\ubb38\uc5d0 \uc2e4\uc81c table\uba85\uc744 \uac16\uc9c0 \ubabb\ud558\uac8c \ub41c \uac83\uc774\ub2e4. \uadf8\ub7ec\ubbc0\ub85c \uc5ec\ub7ec\ubd84\uc758 table\uc5d0 \uad00\ud55c \uc9c0\uc2dd\uacfc \uc704\uc758 \uc815\ubcf4\ub97c \uacb0\ud569\ud558\uc5ec \ub2e4\uc74c\uacfc \uac19\uc774 unload\uc2dc\ucf1c\uc57c \ud55c\ub2e4.
      \n<\/span><\/p>\n

      UNLOAD TABLE emp ( empno number, ename char, job char, mgr number,
      \n<\/span><\/p>\n

      hiredate date, sal number, comm number deptno number)
      \n<\/span><\/p>\n

      STORAGE ( TABNO 0 EXTENTS( FILE 1 BLOCK 10530));
      \n<\/span><\/p>\n

      \uc989 \uc704\uc758 \ud14c\uc774\ube14\uc774\ub984\uacfc \uceec\ub7fc\uba85, data type\uc744 \uc815\uc758\ud558\uace0 scan.out\uc5d0\uc11c \ucc3e\uc740 table\uc758 storage\uc808\uc744 \ud568\uaed8 \uc815\uc758\ud558\uc5ec Unload\ub97c \uc218\ud589\ud55c\ub2e4.
      \n<\/span><\/p>\n

      5.Table(emp)\uc758 unload \uc608:
      \n<\/span><\/p>\n

      $ dul
      \n<\/span><\/p>\n

      UnLoader: Version 2.0.0.0 – Very Restricted on Tue May 16 11:46:33 1995
      \n<\/span><\/p>\n

      Copyright (c) 1994\/95 Oracle Corporation, The Netherlands. All rights reserved.
      \n<\/span><\/p>\n

      Loaded 350 segments
      \n<\/span><\/p>\n

      Loaded 204 extents
      \n<\/span><\/p>\n

      Extent map sorted
      \n<\/span><\/p>\n

      DUL> UNLOAD TABLE emp ( empno number, ename char, job char, mgr number,
      \n<\/span><\/p>\n

      DUL 2> hiredate date, sal number, comm number deptno number)
      \n<\/span><\/p>\n

      DUL 3> STORAGE ( TABNO 0 EXTENTS( FILE 1 BLOCK 10530));
      \n<\/span><\/p>\n

      . unloading table EMP 14 rows unloaded
      \n<\/span><\/p>\n

      DUL>quit
      \n<\/span><\/p>\n

      \u203bscan.out\uc744 \uc774\uc6a9\ud574 unload\uc2dc\uc5d0\ub294 user\ub098 db\ub2e8\uc704\ub85c unload\ub294 \ubd88\uac00\ub2a5\ud558\ub2e4.
      \n<\/span><\/p>\n

      \n <\/p>\n<\/p>\n

      7.Dul\uc744 \uc774\uc6a9\ud574 unload\ud6c4 Reload\uc2dc \uc8fc\uc758\ud560 \uc810
      \n<\/span><\/h3>\n<\/p>\n<\/li>\n
    6. DUL\uc744 \uc774\uc6a9\ud574 unload\ud558\uba74 \ud558\ub098\uc758 table\uc5d0 \ub300\ud558\uc5ec .ctl\uacfc .dat \ub450\uac1c\uc758 file\uc774 \uc0dd\uc131\ub418\uba70 User \ub2e8\uc704\ub85c Unload\ud558\uba74 \ud574\ub2f9 User\uac00 \uac16\uace0 \uc788\ub294 Table\uc758 \uac1c\uc218\ub9cc\ud07c .ctl\uacfc .dat\uac00 \uc0dd\uae34\ub2e4.
      \n<\/span><\/li>\n
    7. .ctl file\uc740 SQL*Loader\uc5d0\uc11c \uc774\uc6a9\ud558\ub294 control file\ub85c\uc11c control file\ub0b4\uc5d0\ub294 data load\ubc29\ubc95\uacfc \uc800\uc7a5\ud560 data\uac00 \uc788\ub294 SAM file\uc5d0 \uad00\ud55c \uc815\ubcf4\uac00 \uc788\ub2e4. \uc774\uc911\uc5d0\uc11c input file\uc758 field\uc815\ubcf4\uc5d0\uc11c \uc815\ubcf4\uac00 \uc2e4\uc81c\uc640 \ud2c0\ub9b4 \uacbd\uc6b0\uc5d0\ub294 SQL*Loader\ub97c \uc774\uc6a9\ud574 load\uc2dc error\uac00 \ubc1c\uc0dd\ud55c\ub2e4.
      \uc774\uc640 \uac19\uc740 \ud604\uc0c1\uc740 \ud56d\uc0c1 \ubc1c\uc0dd\ub418\uc9c0\ub294 \uc54a\uc9c0\ub9cc H\/W Platform\uc5d0 \ub530\ub77c \uc774\ub7f0 \uacbd\uc6b0\uac00 \uc788\ub294 \uac83\uc73c\ub85c \uc0dd\uac01\ub41c\ub2e4
      \n<\/span><\/li>\n
    8. DUL\uc744 \uc0ac\uc6a9\ud574 Recovery\ud560 \ub54c\ub294 SQL*Loader\ub97c \uc774\uc6a9\ud574 data\ub97c \ubcf5\uad6c \ud558\ubbc0\ub85c Load\ud558\uae30 \uc804\uc5d0 \ubbf8\ub9ac table\uc744 create\ud558\uc5ec\uc57c \ud558\ubbc0\ub85c table create script\ub97c \ubc18\ub4dc\uc2dc \uac16\uace0 \uc788\uc5b4\uc57c \ud55c\ub2e4.
      \ub9cc\uc57d, create script\uac00 \uc5c6\ub2e4\uba74 input file(.dat file)\uacfc control file(.ctl file)\uc744 \uc774\uc6a9\ud574 create\ud558\uc5ec\uc57c \ud558\ub294 \ubb38\uc81c\uac00 \uc0dd\uae30\uba74 \uc774\ub807\uac8c create\ud558\uc600\ub2e4\uba74 \ucc98\uc74c \uc0c1\ud0dc\uc640 \ub3d9\uc77c\ud558\uac8c \ub9cc\ub4e4\uc5b4 \uc84c\ub2e4\uace0 \ubcf4\uc7a5\ud558\uae30 \uc5b4\ub824\uc6cc application\uc774 \ube44\uc815\uc0c1\uc801\uc73c\ub85c \uc6b4\uc601 \ub420 \uc218 \uc788\ub2e4.
      \n<\/span><\/li>\n
    9. \n
      \n <\/div>\n

      \n <\/p>\n<\/p>\n

      8.SQL*Loader \uc774\uc6a9\ud560 \ub54c \ubc1c\uc0dd \uac00\ub2a5\ud55c error\uc640 \ud574\uacb0\ucc45
      \n<\/span><\/h3>\n<\/p>\n

      233827 LOADER REJECTS MULTI-LINE RECORDS IF USING ‘TERMINATED
      \n<\/span><\/p>\n

      BY WHITESPACE’
      \n<\/span><\/p>\n

      DESCRIPTION: Load of multi line records fails if the continuation is
      \n<\/span><\/p>\n

      between columns.
      \n<\/span><\/p>\n

      WORK AROUND: Use larger physical records (init.dul:
      \n<\/span><\/p>\n

      LDR_PHYS_REC_SIZE)
      \n<\/span><\/p>\n

      FIXED: 7.3
      \n<\/span><\/p>\n

      250325 CANNOT LOAD CHAR THAT’S USED AS ENCLOSING CHARACTER
      \n<\/span><\/p>\n

      DESCRIPTION: The stutter syntax of a column that starts with an
      \n<\/span><\/p>\n

      enclosing character is not parsed correctly. (“””string itself enclosed
      \n<\/span><\/p>\n

      in quotes””” is not parsed correctly).
      \n<\/span><\/p>\n

      WORK AROUND: Use other enclosing character. (init.dul:
      \n<\/span><\/p>\n

      LDR_ENCLOSE_CHAR)
      \n<\/span><\/p>\n

      FIXED: 7.1.6<\/span>
      \n\t\t\t\t\t<\/span><\/span><\/p>\n

      \n <\/p>\n<\/p>\n

      9.\uc798\ubabb\ub41c init.dul parameter\ub85c \uc57c\uae30 \ub418\ub294 \ubb38\uc81c \uc608
      \n<\/span><\/h3>\n<\/p>\n

      WRONG osd_dba_file_bits size
      \n<\/strong><\/span><\/p>\n

      This can generate output similar to below. Normally this should not happen since you should create a demo database and check this via
      \n<\/span><\/p>\n

      the DUL documented (in html page) query.
      \n<\/span><\/p>\n

      The mismatch in DBA’s is only in the file number (first number in brackets) part. The second number, the block number, is correct.
      \n<\/span><\/p>\n

      \n <\/p>\n

      Data UnLoader: Release 3.2.0.1 – Internal Use Only – on Wed Sep 3 10:40:33 1997
      \n<\/span><\/p>\n

      Copyright (c) 1994\/95 Oracle Corporation, The Netherlands. All rights reserved.
      \n<\/span><\/p>\n

      Session altered.
      \n<\/span><\/p>\n

      Session altered.
      \n<\/span><\/p>\n

      Session altered.
      \n<\/span><\/p>\n

      Session altered.
      \n<\/span><\/p>\n

      Session altered.
      \n<\/span><\/p>\n

      DUL: Warning: Block[1][2] DBA in block mismatch [4][2]
      \n<\/span><\/p>\n

      DUL: Warning: Bad cache layer header file#=1, block#=2
      \n<\/span><\/p>\n

      DUL: Warning: Block[1][3] DBA in block mismatch [4][3]
      \n<\/span><\/p>\n

      DUL: Warning: Bad cache layer header file#=1, block#=3
      \n<\/span><\/p>\n

      ………..and etc……….
      \n<\/span><\/p>\n

      \n <\/p>\n

      WRONG osd_file_leader_size
      \n<\/strong><\/span><\/p>\n

      This may create output similar to below, but many other flavours are possible. In this case we are a fixed number of blocks off. The file
      \n<\/span><\/p>\n

      number is correct. The difference in the block numbers is constant.:
      \n<\/span><\/p>\n

      \n <\/p>\n

      Data UnLoader: Release 3.2.0.1 – Internal Use Only – on Wed Sep 3 10:44:23 1997
      \n<\/span><\/p>\n

      Copyright (c) 1994\/95 Oracle Corporation, The Netherlands. All rights reserved.
      \n<\/span><\/p>\n

      Session altered.
      \n<\/span><\/p>\n

      Session altered.
      \n<\/span><\/p>\n

      Session altered.
      \n<\/span><\/p>\n

      Session altered.
      \n<\/span><\/p>\n

      Session altered.
      \n<\/span><\/p>\n

      \n <\/p>\n

      DUL: Warning: Block[1][2] DBA in block mismatch [1][3]
      \n<\/span><\/p>\n

      DUL: Warning: Bad cache layer header file#=1, block#=2
      \n<\/span><\/p>\n

      DUL: Warning: Block[1][3] DBA in block mismatch [1][4]
      \n<\/span><\/p>\n

      DUL: Warning: Bad cache layer header file#=1, block#=3
      \n<\/span><\/p>\n

      ………..and etc……….
      \n<\/span><\/p>\n

      \n <\/p>\n

      WRONG osd_c_struct_alignment
      \n<\/strong><\/span><\/p>\n

      This may generate output similar to the following:
      \n<\/span><\/p>\n

      Data UnLoader: Release 3.2.0.1 – Internal Use Only – on Wed Sep 3 10:46:10 1997
      \n<\/span><\/p>\n

      Copyright (c) 1994\/95 Oracle Corporation, The Netherlands. All rights reserved.
      \n<\/span><\/p>\n

      Session altered.
      \n<\/span><\/p>\n

      Session altered.
      \n<\/span><\/p>\n

      Session altered.
      \n<\/span><\/p>\n

      Session altered.
      \n<\/span><\/p>\n

      Session altered.
      \n<\/span><\/p>\n

      . unloading table OBJ$
      \n<\/span><\/p>\n

      \n <\/p>\n

      DUL: Warning: file# 0 is out of range
      \n<\/span><\/p>\n

      DUL: Warning: Cannot read data block file#=0, block# = 262145
      \n<\/span><\/p>\n

      OS error 2: No such file or directory
      \n<\/span><\/p>\n

      DUL: Warning: file# 0 is out of range
      \n<\/span><\/p>\n

      DUL: Warning: Cannot read data block file#=0, block# = 262146
      \n<\/span><\/p>\n

      OS error 2: No such file or directory
      \n<\/span><\/p>\n

      ………..and etc……….
      \n<\/span><\/p>\n

      \n <\/p>\n

      WRONG db_block_size
      \n<\/strong><\/span><\/p>\n

      The following output was generated when the db_block_size was set too
      \n<\/span><\/p>\n

      small. The correct value was 4096 and it was set to 2048. Normally, the
      \n<\/span><\/p>\n

      value for this parameter should be taken from the Oracle instances’s init.ora
      \n<\/span><\/p>\n

      file and will not be correctly set.
      \n<\/span><\/p>\n

      \n <\/p>\n

      Data UnLoader: Release 3.2.0.1 – Internal Use Only – on Thu Sep 4 12:38:25 1997
      \n<\/span><\/p>\n

      Copyright (c) 1994\/95 Oracle Corporation, The Netherlands. All rights reserved.
      \n<\/span><\/p>\n

      Session altered.
      \n<\/span><\/p>\n

      Session altered.
      \n<\/span><\/p>\n

      Session altered.
      \n<\/span><\/p>\n

      Session altered.
      \n<\/span><\/p>\n

      Session altered.
      \n<\/span><\/p>\n

      DUL: Warning: Block[1][2] DBA in block mismatch [513][1159680]
      \n<\/span><\/p>\n

      DUL: Warning: File=1, block 2: illegal block version 2
      \n<\/span><\/p>\n

      DUL: Warning: Block[1][2] Illegal block type[0]
      \n<\/span><\/p>\n

      DUL: Warning: Bad cache layer header file#=1, block#=2
      \n<\/span><\/p>\n

      \n <\/p>\n

      DUL: Warning: Block[1][4] DBA in block mismatch [1][2]
      \n<\/span><\/p>\n

      DUL: Warning: File[1]Block[4]INCSEQ mismatch[90268!=0]
      \n<\/span><\/p>\n

      DUL: Warning: Bad cache layer header file#=1, block#=4
      \n<\/span><\/p>\n

      \n <\/p>\n

      DUL: Warning: Block[1][6] DBA in block mismatch [1][3]
      \n<\/span><\/p>\n

      DUL: Warning: File[1]Block[6]INCSEQ mismatch[139591710!=86360346]
      \n<\/span><\/p>\n

      DUL: Warning: Bad cache layer header file#=1, block#=6
      \n<\/span><\/p>\n

      ………..and etc……….
      \n<\/span><\/p>\n

      QUOTE MISSING
      \n<\/strong><\/span><\/p>\n

      If you get the follwing error it is caused by the data dictionary tables “USER$, OBJ$, TAB$ and COL$” not being
      \n<\/span><\/p>\n

      correctly generated. To fix this error simply delete all dictv6.ddl or dictv7.ddl created .dat and .ctl files and restart.
      \n<\/span><\/p>\n

      \n <\/p>\n

      Data UnLoader: Release 3.2.0.1 – Internal Use Only – on Wed Sep 3 10:49:30 1997
      \n<\/span><\/p>\n

      Copyright (c) 1994\/95 Oracle Corporation, The Netherlands. All rights reserved.
      \n<\/span><\/p>\n

      DUL: Error: Quote missing
      \n<\/span><\/p>\n<\/p>\n

      3.\uc0ac\uc6a9 \uc608
      \n<\/span><\/h2>\n<\/p>\n

      \n <\/p>\n<\/p>\n

      1.NT4.0\uc5d0\uc11c\uc758 Oracle 8.0.5 test
      \n<\/span><\/h3>\n<\/p>\n

      ORACLE_HOME\ubc11\uc5d0 BIN\uc5d0 dul8 copy
      \n<\/span><\/p>\n

      ORACLE_HOME\/dul\/bin\/common Directory \uc0dd\uc131
      \n<\/span><\/p>\n

      ORACLE_HOME\/dul\/bin\/common\uc5d0 init.dul\uacfc control.dul\uc744 \ub2e4\uc74c\uacfc \uac19\uc774 \uc0dd\uc131
      \n<\/span><\/p>\n

      NT\uc5d0\uc11c \uc904 \uc218 \uc788\ub294 \ud30c\ub77c\uba54\ud130\ub294 \ub2e4\uc74c\uacfc \uac19\ub2e4.
      \n<\/span><\/p>\n

      \n <\/p>\n

      ———————————————————————————
      \n<\/span><\/p>\n

      init.dul\uc5d0\uc11c \uc124\uc815\ud55c \uac12
      \n<\/strong><\/span><\/p>\n

      # sample init.dul configuration parameters FOR WINNT
      \n<\/span><\/p>\n

      # these must be big enough for the database in question
      \n<\/span><\/p>\n

      # the cache must hold all entries from the dollar tables.
      \n<\/span><\/p>\n

      dc_columns = 200000
      \n<\/span><\/p>\n

      dc_tables = 10000
      \n<\/span><\/p>\n

      dc_objects = 10000
      \n<\/span><\/p>\n

      dc_users = 40
      \n<\/span><\/p>\n

      \n <\/p>\n

      # OS specific parameters
      \n<\/span><\/p>\n

      osd_big_endian_flag = false
      \n<\/span><\/p>\n

      osd_dba_file_bits = 10
      \n<\/span><\/p>\n

      osd_c_struct_alignment = 32
      \n<\/span><\/p>\n

      osd_file_leader_size = 1
      \n<\/span><\/p>\n

      \n <\/p>\n

      # database parameters
      \n<\/span><\/p>\n

      db_block_size = 2048
      \n<\/span><\/p>\n

      \n <\/p>\n

      # loader format definitions
      \n<\/span><\/p>\n

      LDR_ENCLOSE_CHAR = ”
      \n<\/span><\/p>\n

      LDR_PHYS_REC_SIZE = 81
      \n<\/span><\/p>\n

      \n <\/p>\n

      compatible=8
      \n<\/span><\/p>\n

      ———————————————————————————
      \n<\/span><\/p>\n

      ———————————————————————————
      \n<\/span><\/p>\n

      Contol.dul\uc5d0\uc11c \uc124\uc815\ud55c \uac12
      \n<\/strong><\/span><\/p>\n

      0 1 C:\\ORANT\\DATABASE\\SYS1ORCL.ORA
      \n<\/span><\/p>\n

      1 2 C:\\ORANT\\DATABASE\\USR1ORCL.ORA
      \n<\/span><\/p>\n

      2 3 C:\\ORANT\\DATABASE\\RBS1ORCL.ORA
      \n<\/span><\/p>\n

      3 4 C:\\ORANT\\DATABASE\\TMP1ORCL.ORA
      \n<\/span><\/p>\n

      5 5 C:\\ORANT\\DATABASE\\WS_DATA1.ORA
      \n<\/span><\/p>\n

      6 6 C:\\ORANT\\DATABASE\\WS_IDX1.ORA
      \n<\/span><\/p>\n

      7 7 C:\\ORANT\\DATABASE\\OEM_DATA1.ORA
      \n<\/span><\/p>\n

      ———————————————————————————
      \n<\/span><\/p>\n

      \n <\/p>\n

      CASE1) DUL\uc5d0\uc11c \ub370\uc774\ud130 \uc0ac\uc804(data dictionary)\uc774 \uc0ac\uc6a9 \uac00\ub2a5\ud560 \uacbd\uc6b0
      \n<\/span><\/p>\n

      ORACLE_HOME\/dul\/bin\/common>dul dictv8.ddl
      \n<\/span><\/p>\n

      \n <\/p>\n

      ORACLE_HOME\/dul\/bin\/common> dul8
      \n<\/span><\/p>\n

      Dul> unload database; \/ unload user scott; \uc2e4\ud589.
      \n<\/span><\/p>\n

      \n <\/p>\n

      ……………………
      \n<\/span><\/p>\n

      \n <\/p>\n

      CASE2) DUL\uc5d0\uc11c \ub370\uc774\ud130 \uc0ac\uc804(data dictionary)\uc774 \uc0ac\uc6a9 \ubd88\uac00\ub2a5\ud560 \uacbd\uc6b0
      \n<\/span><\/p>\n

      ORACLE_HOME\/dul\/bin\/common> dul8
      \n<\/span><\/p>\n

      DUL> scan database;
      \n<\/span><\/p>\n

      tablespace 0, data file 1: 30719 blocks scanned
      \n<\/span><\/p>\n

      tablespace 1, data file 2: 4095 blocks scanned
      \n<\/span><\/p>\n

      tablespace 2, data file 3: 5119 blocks scanned
      \n<\/span><\/p>\n

      tablespace 3, data file 4: 8703 blocks scanned
      \n<\/span><\/p>\n

      tablespace 5, data file 5: 10239 blocks scanned
      \n<\/span><\/p>\n

      tablespace 6, data file 6: 15359 blocks scanned
      \n<\/span><\/p>\n

      tablespace 7, data file 7: 5119 blocks scanned
      \n<\/span><\/p>\n

      \ud558\uba74 EXT.dat\uc640 SEG.dat\uac00 \uc0dd\uae34\ub2e4.
      \n<\/span><\/p>\n

      Echo scan tables; | dul 8> scan.out
      \n<\/span><\/p>\n

      \ud558\uace0 \uacb0\uacfc\ub97c \ubd84\uc11d\ud574 \uc801\ub2f9\ud55c \ud14c\uc774\ube14\uc744 \ucc3e\uc544 sql*loader\ub85c Unload\ud55c\ub2e4
      \n<\/span><\/p>\n

      .
      \n<\/span><\/p>\n

      \n <\/p>\n<\/p>\n

      2.hp \uc5d0\uc11c\uc758 oracle 7.3.3 test
      \n<\/span><\/h3>\n<\/p>\n

      ———————————————————————————
      \n<\/span><\/p>\n

      init.dul\uc5d0\uc11c \uc124\uc815\ud55c \uac12
      \n<\/strong><\/span><\/p>\n

      # sample init.dul configuration parameters FOR hp, oracle7
      \n<\/span><\/p>\n

      # these must be big enough for the database in question
      \n<\/span><\/p>\n

      # the cache must hold all entries from the dollar tables.
      \n<\/span><\/p>\n

      dc_columns = 200000
      \n<\/span><\/p>\n

      dc_tables = 10000
      \n<\/span><\/p>\n

      dc_objects = 10000
      \n<\/span><\/p>\n

      dc_users = 40
      \n<\/span><\/p>\n

      \n <\/p>\n

      # OS specific parameters
      \n<\/span><\/p>\n

      osd_big_endian_flag = true
      \n<\/span><\/p>\n

      osd_dba_file_bits = 6
      \n<\/span><\/p>\n

      osd_c_struct_alignment = 32
      \n<\/span><\/p>\n

      osd_file_leader_size = 1
      \n<\/span><\/p>\n

      \n <\/p>\n

      # database parameters
      \n<\/span><\/p>\n

      db_block_size = 2048
      \n<\/span><\/p>\n

      \n <\/p>\n

      # loader format definitions
      \n<\/span><\/p>\n

      LDR_ENCLOSE_CHAR = ”
      \n<\/span><\/p>\n

      LDR_PHYS_REC_SIZE = 81
      \n<\/span><\/p>\n

      \n <\/p>\n

      compatible=7
      \n<\/span><\/p>\n

      ———————————————————————————
      \n<\/span><\/p>\n

      ———————————————————————————
      \n<\/span><\/p>\n

      Contol.dul\uc5d0\uc11c \uc124\uc815\ud55c \uac12
      \n\t\t\t\t\t\t<\/span><\/strong><\/span><\/p>\n

      1 \/home2\/ora733\/oradata\/test733\/system01.dbf
      \n<\/span><\/p>\n

      2 \/home2\/ora733\/oradata\/test733\/rbs01.dbf
      \n<\/span><\/p>\n

      3 \/home2\/ora733\/oradata\/test733\/temp02.dbf
      \n<\/span><\/p>\n

      4 \/home2\/ora733\/oradata\/test733\/tools01.dbf
      \n<\/span><\/p>\n

      5 \/home2\/ora733\/oradata\/test733\/users01.dbf
      \n<\/span><\/p>\n

      6 \/home2\/ora733\/oradata\/test733\/users02.dbf
      \n<\/span><\/p>\n

      ———————————————————————————-
      \n<\/span><\/p>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

        \uc774 document\ub294 version8\uc5d0 \uae30\ubc18\ud558\uc5ec upgrade\ud558\uc600\ub2e4. \ub610\ud55c \ub2e8\uc21c\uc774 dul executable\uacfc \ud568\uaed8 download\ubc1b\ub294 usg.html\uc744 \ubc88\uc5ed\ud55c \uac83\uc774 \uc544\ub2c8\ub77c \uadf8 \ub3d9\uc548 dul\uc744 \uc0ac\uc6a9\ud558\uba74\uc11c \uc313\uc544 \uc654\ub358 \uacbd\ud5d8 \ub4f1\uc744 \ud568\uaed8 \uc368\ub193\uc558\uace0 raw device dul\uc744 \uc0ac\uc6a9\ud558\ub294\ub370 \ud544\uc694\ud55c \ub0b4\uc6a9\ub3c4 \uc368\ub193\uc558\ub2e4 \uc774 document\uac00 site\ub97c \uc9c0\uc6d0\ud558\ub294 Engineer\uc5d0\uac8c \uc870\uae08\uc774\ub77c\ub3c4 \ub3c4\uc6c0\uc774 \ub410\uc73c\uba74 \ud558\ub294 \ubc14\ub78c\uc744 \uac00\uc9c4\ub2e4. 1. \uac1c\uc694   1. Dul\uc758 \uc6d0\ub9ac\uc640 \ud2b9\uc9d5 \uacf5\uc2dd \uc9c0\uc6d0 utility\uac00 \uc544\ub2c8\ub2e4. […]<\/p>\n","protected":false},"author":1,"featured_media":637,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[14],"tags":[295,296,297],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/1\/cfile23.uf.271FE245563C66303020FD.png?fit=509%2C45","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/636"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=636"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/636\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/637"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=636"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=636"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=636"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}