Select to view content in your preferred language

ORA-01445 Error on query or select

1409
0
09-20-2011 08:11 AM
CameronMcCormick
Regular Contributor
Hello,
I found some information regarding the ORA-01445 error on another thread,
http://forums.arcgis.com/threads/32189-Querying-an-SDE-view-in-ArcMap-returns-ORA-01445-error?highli....  Great information!

My only question is: Is there a way to make this work with a regular SDE connection (not using direct connect) and not have the error returned?  The error returned is:
[ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table]


We have quite a few people that would like to use this newly created feature class but our department does not want the overhead of installing and maintaining oracle clients on many PCs.  Is there a way around this?
Many thanks for the help,
Cameron McCormick
0 Kudos
0 Replies