D:/oradata/EYGLE/DATAFILE>aul4b.exe
Register Code: 25FV-NFCH-B53H-RO9V-SZHV
AUL : AnySQL UnLoader(MyDUL) for Oracle 8/8i/9i/10g, release 4.0.1
(C) Copyright Lou Fangxin 2005-2006 (AnySQL.net), all rights reserved.AUL> open crl.txt* ts# fno rfn ver bsize blocks filename
- ---- ---- ---- --- ----- ---------- -----------------------------------
Y 4 4 4 a2 8192 640 O1_MF_USERS_2G8OJYYS_.DBF
AUL> scan extents
2007-02-02 10:52:09
2007-02-02 10:52:09
AUL> scan table to table.txt
2007-02-02 10:52:29
2007-02-02 10:52:29AUL> list table eygle;
UNLOAD TABLE eygle.EYGLE TO EYGLE.txt;
UNLOAD TABLE eygle.EYGLE_BLOB TO EYGLE_BLOB.txt;
AUL> UNLOAD TABLE eygle.EYGLE_BLOB TO EYGLE_BLOB.txt;
2007-02-02 10:58:16
Unload OBJD=14367 FILE=4 BLOCK=19 CLUSTER=0 ...
2007-02-02 10:58:16
AUL>

E:/rec/bloBTest>sqlldr eygle/eygle control=EYGLE_BLOB_sqlldr.ctl SQL*Loader: Release 10.2.0.1.0 - PRodUCtion on 星期五 2月 2 11:43:32 2007Copyright (c) 1982, 2005, Oracle. All rights reserved.SQL*Loader-292: 加載 xml, LOB 或 VARRAY 列時忽略 ROWS 參數加載完成 - 邏輯記錄計數 2。E:/rec/blobtest>sqlplus "/ as sysdba"SQL*Plus: Release 10.2.0.1.0 - Production on 星期五 2月 2 11:43:41 2007Copyright (c) 1982, 2005, Oracle. All rights reserved.
連接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining optionsSQL> connect eygle/eygle
已連接。
SQL> desc eygle_blob;
名稱 是否為空? 類型
----------------------------------------- -------- ----------------------------
FID NUMBER
FNAME VARCHAR2(50)
FDESC VARCHAR2(200)
FPIC BLOBSQL> select fid,fname,length(fpic) from eygle_blob;FID FNAME LENGTH(FPIC)
---------- -------------------------------------------------- ------------
1 1.jpg 333769
2 2.jpg 300332
1 1.jpg 333769
2 2.jpg 300332
SQL>