DBA Tools

How AUL support the partition table's CLOB/BLOB recovery?

    When you prepare to do recovery of partitioned table with LOB columns with AUL4, you must modify the LOB index's partition name first in "AULOBJ.TXT". I have thought that the LOB index have the same partition name with...

Posted on October 11, 2007 5:17 PM

How AUL support different Oracle CLOB/BLOB chunk size?

    All the blocks of a chunk must be continual with a single extent, because you cannot specify a chunk size larger than the next extent size. Based on this rule, I add different chunk size support to AUL...

Posted on October 11, 2007 5:13 PM

How to modify the storage properties of XMLTYPE type?

    Few days ago, I told one of my friends that the XMLTYPE column equals to CLOB type, that is not true, it's an object type. Later he ask me how to modify the cache property of XMLTYPE column,...

Posted on October 10, 2007 5:24 PM

How much files can be stored in one directory?

    How many files can be stored in on directory? I don't know the answer. But when one directory have a lot of files, it will be very hard to operate, and may slow down the file access speed....

Posted on October 10, 2007 3:08 PM

Some LOB recovery related options in AUL/MyDUL utility.

    AUL version 4 support LOB data type, including inline LOB, in row LOB and out of row LOB. I need to introduce few new options of AUL, the following two are only related to CLOB data type:  ...

Posted on October 10, 2007 3:04 PM

Oracle Bug : exp-00003 when export tables with LOB columns

    When you use old version of exp to export tables with LOB column from Oracle 9.2.0.5 or higher version, you will get an error "EXP-00003 : no storage definition found for segment .....", actually this is an Oracle...

Posted on September 29, 2007 12:12 PM

How to upload OS files to LOB columns with Oracle SQL Loader

    By DBMS_LOB PL/SQL package I cannot load client OS files to LOB columns, you can either use lobs utility, or use Oracle's SQL Loader (sqlldr) to do this job.     I have the following OS files in...

Posted on September 13, 2007 11:37 AM

Unload LOBs to OS files or upload OS files to LOBs in Oracle

    Oracle CLOB and BLOB data types can be used to store long text or large images, provide better performance compare to the LONG and LONG RAW data types for row accessing. However it's not easy to manipulate them...

Posted on September 12, 2007 8:32 PM