Re: changing ROWID
From: Alvin Law <alaw_at_oracle.com>
Date: 20 Jan 95 14:55:59
Message-ID: <ALAW.95Jan20145559_at_ap226sun.oracle.com>
Date: 20 Jan 95 14:55:59
Message-ID: <ALAW.95Jan20145559_at_ap226sun.oracle.com>
In article <3fjjli$ql8$1_at_mhadf.production.compuserve.com> Steve Edelstein <74160.645_at_CompuServe.COM> writes:
> Clarifying the post:
>
> 1. 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.
This is possible when you are using a database link, which could be transparent to you with proper use of synonyms (by transparent I mean without looking at the data dictionary).
-- "And this is all I have to say about that..." - F. Gump ___ (o o) +-oo0-\_/-0oo---------------------------------------------------------------+ | Alvin W. Law ..... Oracle Corporation ....... Email: alaw_at_us.oracle.com | +---------------------------------------------------------------------------+ ORA-03113: end-of-file on communication channelReceived on Fri Jan 20 1995 - 14:55:59 CET