Re: changing ROWID
From: Steve Edelstein <74160.645_at_CompuServe.COM>
Date: 18 Jan 1995 17:37:54 GMT
Message-ID: <3fjjli$ql8$1_at_mhadf.production.compuserve.com>
Date: 18 Jan 1995 17:37:54 GMT
Message-ID: <3fjjli$ql8$1_at_mhadf.production.compuserve.com>
Clarifying the post:
- Two rows from different tables CANNOT share a rowid. Each rowid is a usique address for a single row of a single table. Imagine what would happen if 2 rows could share a rowid: when you selected one, Oracle wouldn't be able to figure out which one.
- When an update causes a chaining to a new block (to hold the extended data for that record), the rowid is the same as before the update.
Hope I'm not belaboring this...
-- Steve Edelstein VOICE: 212-956-3670 Relational Business Systems CompuServe: 74160,645 124 West 60th Street Suite 47C Author of New York, NY 10023 "Learning Oracle Forms"Received on Wed Jan 18 1995 - 18:37:54 CET