Re: Performance issue while loading large amount of data

"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message news:E2F6A70FE45242488C865C3BC1245DA7032B699A_at_lnewton.leeds.lfs.co.uk...
> Hi Richard,
>
> nice bedtime reading there - thanks, I need to look into this stuff in
> more detail. (If Niall wants to call me a geek, then so be it !)
>
> A quick question for you, I have a couple of rows in a table which are
> giving the old 'integer overflow' error from time to time. I suspect the
> problem is data but I'm not sure. I was wondering how I can get from a
> rowid to a file & block number ready for a dump. Can it be done ?
>

Hi Norman:

The ROWID is either constructed of BLOCK# - ROW# - FILE# or OBJECTID-FILE#-BLOCK#-ROW#, depending on whether you are working in Oracle 7 or anything else, and also depending on whether you are talking about the restricted or extended rowid format as invented in Oracle 8 and above.

To take a ROWID and turn it into its component parts, you either want to start learning Base-64 encoding very, very quickly (always good for a wet Wednesday afternoon) or use the DBMS_ROWID package as supplied by your good friends, Oracle Corporation, and created by running catproc.sql (so it should already be there).

Regards
HJR
> I'm on 64bit 9iR2 on HPUX 11 64 bit with 8174 client on Win NT4.
>
> cheers,
> Norman.
>
> -------------------------------------
> Norman Dunbar
> Database/Unix administrator
> Lynx Financial Systems Ltd.
> mailto:Norman.Dunbar_at_LFS.co.uk
> Tel: 0113 289 6265
> Fax: 0113 289 3146
> URL: http://www.Lynx-FS.com
> -------------------------------------
>
Received on Wed Jan 15 2003 - 17:48:25 CST