| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Rowid problem
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
 |
 |