GDUL 1.0.2加入了简单的调试功能(118楼),最近有些忙，开发工作暂停一个月

显示全部楼层 · 2006-9-4 01:02:51

目前支持.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:[email protected].
GDUL>bootstrap
bootstrap finished.
GDUL>list user
IdName
0 SYS
5 SYSTEM
11OUTLN
19DIP
21TSMSYS
24DBSNMP
25ORACLE_OCM
26SYSMAN
28MGMT_VIEW
30GYH
GDUL>set user gyh
GDUL>list table
IdName
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 [table]
exit|quit
list datafile
list user:list users of database
list table: list table of current user
unload table [table]:unload table rows to TXT
unload user
rowid
rdba
show user:show current user
show table [table]
set user
version
GDUL>
[ 本帖最后由 gengyonghui 于 2008-12-31 10:12 编辑 ]

千问 · 2006-9-4 01:02:51

佩服佩服，先下来看看！
老大，给个说明书一类的吧！
咋用呢？
[ 本帖最后由 Allen2312 于 2008-12-2 10:36 编辑 ]

千问 · 2006-9-4 01:02:51

::::::::::::::
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,否则导出成文本。

千问 · 2006-9-4 01:02:51

well done

千问 · 2006-9-4 01:02:51

下了，多谢

千问 · 2006-9-4 01:02:51

看看不错

千问 · 2006-9-4 01:02:51

精华！！

千问 · 2006-9-4 01:02:51

bug no.1
在windows下，version ，显示为：1.0 for linux
呵呵

千问 · 2006-9-4 01:02:51

原帖由 gengyonghui 于 2008-12-2 10:40 发表
::::::::::::::
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,否则导出成文本。
感谢老大无私分享！！！

千问 · 2006-9-4 01:02:51

原帖由 netbbs 于 2008-12-2 10:52 发表
bug no.1
在windows下，version ，显示为：1.0 for linux
呵呵
windows下是今天早晨临时编译的,代码没怎么改