topic ORA-01445 Error on query or select in Data Management Questions https://community.esri.com/t5/data-management-questions/ora-01445-error-on-query-or-select/m-p/425255#M24331 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><SPAN>I found some information regarding the ORA-01445 error on another thread,</SPAN><BR /><A href="http://forums.arcgis.com/threads/32189-Querying-an-SDE-view-in-ArcMap-returns-ORA-01445-error?highlight=ora-01445">http://forums.arcgis.com/threads/32189-Querying-an-SDE-view-in-ArcMap-returns-ORA-01445-error?highlight=ora-01445</A><SPAN>.&nbsp; Great information!</SPAN><BR /><BR /><SPAN>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?&nbsp; The error returned is:</SPAN><BR /><SPAN>[ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table]</SPAN><BR /><BR /><BR /><SPAN>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.&nbsp; Is there a way around this?</SPAN><BR /><SPAN>Many thanks for the help,</SPAN><BR /><SPAN>Cameron McCormick</SPAN></BODY></HTML> Tue, 20 Sep 2011 15:11:46 GMT CameronMcCormick 2011-09-20T15:11:46Z ORA-01445 Error on query or select https://community.esri.com/t5/data-management-questions/ora-01445-error-on-query-or-select/m-p/425255#M24331 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><SPAN>I found some information regarding the ORA-01445 error on another thread,</SPAN><BR /><A href="http://forums.arcgis.com/threads/32189-Querying-an-SDE-view-in-ArcMap-returns-ORA-01445-error?highlight=ora-01445">http://forums.arcgis.com/threads/32189-Querying-an-SDE-view-in-ArcMap-returns-ORA-01445-error?highlight=ora-01445</A><SPAN>.&nbsp; Great information!</SPAN><BR /><BR /><SPAN>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?&nbsp; The error returned is:</SPAN><BR /><SPAN>[ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table]</SPAN><BR /><BR /><BR /><SPAN>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.&nbsp; Is there a way around this?</SPAN><BR /><SPAN>Many thanks for the help,</SPAN><BR /><SPAN>Cameron McCormick</SPAN></BODY></HTML> Tue, 20 Sep 2011 15:11:46 GMT https://community.esri.com/t5/data-management-questions/ora-01445-error-on-query-or-select/m-p/425255#M24331 CameronMcCormick 2011-09-20T15:11:46Z