Question about block dump

From: Mark Moynahan <Mark.Moynahan_at_apollogrp.edu>
Date: Wed, 3 Mar 2004 08:31:56 -0700
Message-ID: <73BB49215339D743903095833FFE4B17DA4DB8@apophxex4.apollogrp.edu>

When doing a block dump is there a way to determine the rowid you're looking for? What if the first column in each row a primary key and has a number datatype. Could that first column be used to determine the row your looking for? If so, how are number datatypes stored internally in Oracle?

for instance, in the trace file the first column looks like this: col 0: [ 5] c4 03 13 54 56

How would I convert this to the actual number in the primary key column?

Thanks,

Mark

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Wed Mar 03 2004 - 09:36:42 CST