ODU的操作实例

SQL> select count(*) from t1;

  COUNT(*)
----------
     50656

SQL> truncate table t1;

Table truncated.

SQL> show user
USER is "AIKI"

ODU> rac2-> ./odu

Oracle Data Unloader trial version 4.1.3

Copyright (c) 2008,2009,2010,2011 XiongJun. All rights reserved.

Web: http://www.oracleodu.com
Email: [e-mail]

loading default config.......

byte_order little
block_size  8192
block_buffers 1024
error at line 3.
db_timezone -7
Invalid db timezone:-7
client_timezone 8
Invalid client timezone:8
asmfile_extract_path   /asmfile
data_path   data
lob_path    /odu/data/lob
charset_name US7ASII
charset name 'US7ASII' not found,will use default charset ZHS16GBK
ncharset_name AL16UTF16
output_format text
lob_storage infile
clob_byte_order big
trace_level 1
delimiter |
unload_deleted no
file_header_offset 0
is_tru64 no
record_row_addr no
convert_clob_charset yes
use_scanned_lob  yes
trim_scanned_blob yes
lob_switch_dir_rows 20000
db_block_checksum yes
db_block_checking yes
rdba_file_bits 10
compatible 10
load config file 'config.txt' successful
loading default asm disk file ......


grp# dsk# bsize ausize disksize diskname        groupname       path
---- ---- ----- ------ -------- --------------- --------------- --------------------------------------------
   1    0  4096  1024K    20473 DG1_0000        DG1             /dev/sdc1
   1    1  4096  1024K    20473 DG1_0001        DG1             /dev/sdd1

load asm disk file 'asmdisk.txt' successful
loading default control file ......


 ts#   fn  rfn bsize   blocks bf offset filename
---- ---- ---- ----- -------- -- ------ --------------------------------------------
   0    1    1  8192    64000 N       0 +DG1/devdb/datafile/system.256.789857087
   4    4    4  8192    45280 N       0 +DG1/devdb/datafile/users.259.789857087
   2    3    3  8192    35840 N       0 +DG1/devdb/datafile/sysaux.257.789857087
   1    2    2  8192    81920 N       0 +DG1/devdb/datafile/undotbs1.258.789857087
   6    5    5  8192    12800 N       0 +DG1/devdb/datafile/example.264.789857173
   5    6    6  8192    25600 N       0 +DG1/devdb/datafile/undotbs2.265.789857285
load control file 'control.txt' successful
loading dictionary data......done

loading scanned data......done

ODU> unload dict
CLUSTER C_USER# file_no: 1 block_no: 89
TABLE OBJ$ file_no: 1 block_no: 121
CLUSTER C_OBJ# file_no: 1 block_no: 25
CLUSTER C_OBJ# file_no: 1 block_no: 25
found IND$'s obj# 19
found IND$'s dataobj#:2,ts#:0,file#:1,block#:25,tab#:3
found TABPART$'s obj# 266
found TABPART$'s dataobj#:266,ts#:0,file#:1,block#:2121,tab#:0
found INDPART$'s obj# 271
found INDPART$'s dataobj#:271,ts#:0,file#:1,block#:2161,tab#:0
found TABSUBPART$'s obj# 278
found TABSUBPART$'s dataobj#:278,ts#:0,file#:1,block#:2217,tab#:0
found INDSUBPART$'s obj# 283
found INDSUBPART$'s dataobj#:283,ts#:0,file#:1,block#:2257,tab#:0
found IND$'s obj# 19
found IND$'s dataobj#:2,ts#:0,file#:1,block#:25,tab#:3
found LOB$'s obj# 151
found LOB$'s dataobj#:2,ts#:0,file#:1,block#:25,tab#:6
found LOBFRAG$'s obj# 299
found LOBFRAG$'s dataobj#:299,ts#:0,file#:1,block#:2393,tab#:0
ODU>
ODU> unload table aiki.t1

Unloading table: T1,object ID: 54523
Unloading segment,storage(Obj#=54523 DataObj#=54646 TS#=4 File#=4 Block#=395 Cluster=0)

0 rows unloaded

----------------------------------------------------------

试用版的非SYSTEM TABLESPACE只能一个块恢复一条数据