« December 2006 | Main | February 2007 »

Prev 1 2

January 2007 Archives

January 31, 2007

Assign HEX value to RDBA optionn in AUL.

    Several commands (OSDUMP, UNLOAD, ORADUMP, BCHECK, CORRUPT, ROWID) of AUL accept an option named RDBA (Relative Data Block Address), a 32 bit unsigned integer consists of relative file number (RFILE#, the highest 10 bits) and data block id (BLOCK#, the lower 22 bits), this value is always printed as a HEX string in Oracle's block dump trace, while in previously version, you are required to convert the HEX string to a integer. But now it was enhanced, you could assign this option a value by providing both an integer or HEX string (by prefix by 0x.

    The following sample show you how to assign a HEX value to RDBA option:

AUL> unload object 10102 rdba 0x0180000f column number char char;
2007-01-29 23:38:38
10|ACCOUNTING|NEW YORK
20|RESEARCH|DALLAS
30|SALES|CHICAGO
40|OPERATIONS|BOSTON
2007-01-29 23:38:38

    Following sample will introduce you a very useful command in AUL, create or analyze an oracle ROWID:

AUL> rowid create object 10102 rdba 0x0180000f slot 0

OBJD  = 10102
RDBA  = 0x0180000f = 25165839
RFN#  = 6
BID#  = 15
SLOT  = 0
ROWID = AAACd2AAGAAAAAPAAA

AUL> ROWID PARSE AAACd2AAGAAAAAPAAA

OBJD  = 10102
RDBA  = 0x0180000f = 25165839
RFN#  = 6
BID#  = 15
SLOT  = 0
ROWID = AAACd2AAGAAAAAPAAA

    Make step slowly, but it's making step forward.

Prev 1 2

About January 2007

This page contains all entries posted to AnySQL.net English in January 2007. They are listed from oldest to newest.

December 2006 is the previous archive.

February 2007 is the next archive.

Many more can be found on the main index page or by looking through the archives.

Creative Commons License
This weblog is licensed under a Creative Commons License.
Powered by
Movable Type 3.34