目前支持.dmp,.ctl两种输出格式,支持blob,clob,
1.0.2已经支持跨平台恢复、IOT表。
# ./gdul
Geng's Data Unloader for Oracle 8i/9i/10g, release 1.0.
Copyright (c) 2007-2008,Andy Geng. All Rights Reserved.
If you have any advises and suggestions,
please contact me:gengyonghui@hotmail.com.
GDUL>bootstrap
bootstrap finished.
GDUL>list user
Id Name
0 SYS
5 SYSTEM
11 OUTLN
19 DIP
21 TSMSYS
24 DBSNMP
25 ORACLE_OCM
26 SYSMAN
28 MGMT_VIEW
30 GYH
GDUL>set user gyh
GDUL>list table
Id Name
12091 BIN$XPjT/Aq0ldHgQAB/AQBKWg==$0
12092 T_NUMBER
12098 T_NUM
12109 T_LONG
12187 T_BLOB1
12190 T_BLOB2
12193 T_CLOB5
12196 T_CLOB8
GDUL>unload table t_num
2008-12-02 10:28:09...unloading table T_NUM 0rows unloaded.
GDUL>unload table t_blob1
2008-12-02 10:30:35...unloading table T_BLOB1 1rows unloaded.
GDUL>unload user gyh
About to unload GYH's tables...
2008-12-02 10:30:39...unloading table BIN$XPjT/Aq0ldHgQAB/AQBKWg==$0 33rows unloaded.
2008-12-02 10:30:39...unloading table T_NUMBER 0rows unloaded.
2008-12-02 10:30:39...unloading table T_NUM 0rows unloaded.
2008-12-02 10:30:39...unloading table T_LONG 0rows unloaded.
2008-12-02 10:30:39...unloading table T_BLOB1 1rows unloaded.
2008-12-02 10:30:39...unloading table T_BLOB2 0rows unloaded.
2008-12-02 10:30:39...unloading table T_CLOB5 2rows unloaded.
2008-12-02 10:30:39...unloading table T_CLOB8 16rows unloaded.
GDUL>help
USAGE:
bootstrap:init dictionary,you should run bootstrap command first
help
desc
exit|quit
list datafile
list user:list users of database
list table: list table of current user
unload table
unload user
rowid
rdba <0xnnnnnnnn>
show user:show current user
show table
set user
version
GDUL>
::::::::::::::
control.gdul
::::::::::::::
1,/software/app/oracle/oradata/test/system01.dbf
2,/software/app/oracle/oradata/test/undotbs01.dbf
3,/software/app/oracle/oradata/test/sysaux01.dbf
4,/software/app/oracle/oradata/test/users01.dbf
上面这个文件是写明相对文件号和文件名
::::::::::::::
init.gdul
::::::::::::::
db_block_size=8192
osd_big_endian_flag=false
block_checksum=true
export_mode=true
ldr_enclose_char=|
file_leader_size=0
上面这个文件是指定参数,export_mode=true会导出成dmp,否则导出成文本。
