Does anyboyd know how many bytes are in the ROWID ??

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 2 Oct 2001 08:24:47 +0100
Message-ID: <F43F5B4264AED511A10F0008C7DBB606153785@leuler.leeds.lfs.co.uk>

Oracle 8 rowids are 10 bytes.
Oracle 7 rowids are 6 bytes.

See concepts manual, V1, page 10.17-10.18 Summary of Oracle Datatype information.

Regards,
Norman.

Norman Dunbar			EMail:	Norman.Dunbar_at_LFS.co.uk
Database/Unix administrator	Phone:	0113 289 6265
				Fax:	0113 289 3146
Lynx Financial Systems Ltd.	URL:	http://www.Lynx-FS.com


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

-----Original Message-----

From: Maggie Evans [mailto:maggie-evans_at_home.com] Posted At: Tuesday, October 02, 2001 3:14 AM Posted To: server
Conversation: Does anyboyd know how many bytes are in the ROWID ?? Subject: Does anyboyd know how many bytes are in the ROWID ??

How many bytes make up the rowid?
I need to know the row id to estimate the size of the index. It has changed since 8.0. Does anybody know what it is? Thanks for any help.

cheers;
Owen Brandon Received on Tue Oct 02 2001 - 02:24:47 CDT