topic What gets edited (or needs edit access) when connecting to an SDE geodatabase? in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/what-gets-edited-or-needs-edit-access-when/m-p/734194#M224 <HTML><HEAD></HEAD><BODY><P>We are using Oracle Data Guard with our production SDE Geodatabase (10.2.1) and want to test using the physical standby database (in readonly mode) as a database for reporting and data extractions.&nbsp; When we tried to connect via ArcCatalog, it failed because the DB is readonly.&nbsp; We assume we will have the same problem using ArcMap.&nbsp; For reporting and data extractions, we probably wouldn't be using ArcCatalog or ArcMap but instead either web services or versioned views (which we haven't tested yet).</P><P></P><P>So my question is what table(s) get updated or require write access when using either ArcCatalog, ArcMap, a web service or a versioned view to connect?&nbsp; I understand the answer may be different depending on the mode of access.&nbsp; Is what we are trying to do (access a geodatabase in readonly mode at the DB level) even possible?</P></BODY></HTML> Thu, 23 Apr 2015 14:33:19 GMT WilliamD_Arcy 2015-04-23T14:33:19Z What gets edited (or needs edit access) when connecting to an SDE geodatabase? https://community.esri.com/t5/geodatabase-questions/what-gets-edited-or-needs-edit-access-when/m-p/734194#M224 <HTML><HEAD></HEAD><BODY><P>We are using Oracle Data Guard with our production SDE Geodatabase (10.2.1) and want to test using the physical standby database (in readonly mode) as a database for reporting and data extractions.&nbsp; When we tried to connect via ArcCatalog, it failed because the DB is readonly.&nbsp; We assume we will have the same problem using ArcMap.&nbsp; For reporting and data extractions, we probably wouldn't be using ArcCatalog or ArcMap but instead either web services or versioned views (which we haven't tested yet).</P><P></P><P>So my question is what table(s) get updated or require write access when using either ArcCatalog, ArcMap, a web service or a versioned view to connect?&nbsp; I understand the answer may be different depending on the mode of access.&nbsp; Is what we are trying to do (access a geodatabase in readonly mode at the DB level) even possible?</P></BODY></HTML> Thu, 23 Apr 2015 14:33:19 GMT https://community.esri.com/t5/geodatabase-questions/what-gets-edited-or-needs-edit-access-when/m-p/734194#M224 WilliamD_Arcy 2015-04-23T14:33:19Z