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: magic007cn@gmail.com
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只能一个块恢复一条数据