Rowid problem

From: Randy Christiansen <randy_christiansen_at_auto-soft.com>
Date: Mon, 14 Aug 2000 11:28:37 -0600
Message-Id: <10589.114515@fatcity.com>

Hello Everybody,

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 BLOB) this view grabs the rowids through an alias which works fine (the alias makes it work).

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

Any ideas?

Thanks,
Randy J. Christiansen
Oracle Guy
Brooks Automation - Auto-Soft Division
Randy.christiansen_at_brooks.com Received on Mon Aug 14 2000 - 12:28:37 CDT