Re: Rowid problem

From: William Beilstein <BeilstWH_at_obg.com>
Date: Tue, 15 Aug 2000 08:22:21 -0400
Message-Id: <10590.114589@fatcity.com>

I would need to see the creation script for the view
>>> Randy Christiansen <randy_christiansen_at_auto-soft.com> 08/14/00 02:47PM =
>>>

Hello Everybody,=20

We are running Oracle 8.0.5.1 on DEC UNIX.

I was wondering if anyone has run into this unique situation and possibly = has a solution:

We have a view that connects 10 tables through union all (poor man's = partitioning, since I have a=20
BLOB) this view grabs the rowids through an alias which works fine (the = alias makes it work).=20

The problem is when we use this list of rowids to get data from these = tables. We consistently=20
get an ORA-01410 "invalid ROWID". We have verified that the rowids do = exist.=20

Any ideas?
=20
Thanks,
Randy J. Christiansen
Oracle Guy=20
Brooks Automation - Auto-Soft Division
Randy.christiansen_at_brooks.com=20

--=20
Author: Randy Christiansen
  INET: randy_christiansen_at_auto-soft.com=20

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Aug 15 2000 - 07:22:21 CDT