Performance issue while loading large amount of data

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Thu, 16 Jan 2003 10:04:59 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7032C9DA4@lnewton.leeds.lfs.co.uk>

Hi Howard,

you know how it is, when you know you know something but can't quite put your finger on what it is you know - especially when you need it !

DBMS_ROWID - I knew that, I've used it, I just didn't remember about it when I needed to.

Thanks for the reminder.

I'm off to use it now :o)

Cheers,
Norman.

PS. Base 64 - no worries, I can do that !

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


-------------------------------------

-----Original Message-----
From: Howard J. Rogers [mailto:howardjr2000_at_yahoo.com.au] Posted At: Wednesday, January 15, 2003 11:48 PM Posted To: server
Conversation: Performance issue while loading large amount of data Subject: Re: Performance issue while loading large amount of data

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 Received on Thu Jan 16 2003 - 04:04:59 CST