topic upgrade a user schema gdb after upgrading the master in Data Management Questions https://community.esri.com/t5/data-management-questions/upgrade-a-user-schema-gdb-after-upgrading-the/m-p/711077#M40271 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><UL style="list-style-type: disc;"><LI>is the user schema gdb means the owner of GIS DATA?</LI></UL><P></P><UL style="list-style-type: disc;"><LI>shall I upgrade the user schema after the upgrade of master schema?</LI></UL><P></P><UL style="list-style-type: disc;"><LI>I have upgrade the master then when connecting to the user who own the GIS Data and then from database properties dialog it marked the upgrade status as attached&nbsp; (matched the release you are currently using) without any upgrade for the user schema? is this O.K?</LI></UL><P>Thanks,</P></BODY></HTML> Thu, 28 May 2020 15:00:46 GMT RedaAli 2020-05-28T15:00:46Z upgrade a user schema gdb after upgrading the master https://community.esri.com/t5/data-management-questions/upgrade-a-user-schema-gdb-after-upgrading-the/m-p/711077#M40271 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><UL style="list-style-type: disc;"><LI>is the user schema gdb means the owner of GIS DATA?</LI></UL><P></P><UL style="list-style-type: disc;"><LI>shall I upgrade the user schema after the upgrade of master schema?</LI></UL><P></P><UL style="list-style-type: disc;"><LI>I have upgrade the master then when connecting to the user who own the GIS Data and then from database properties dialog it marked the upgrade status as attached&nbsp; (matched the release you are currently using) without any upgrade for the user schema? is this O.K?</LI></UL><P>Thanks,</P></BODY></HTML> Thu, 28 May 2020 15:00:46 GMT https://community.esri.com/t5/data-management-questions/upgrade-a-user-schema-gdb-after-upgrading-the/m-p/711077#M40271 RedaAli 2020-05-28T15:00:46Z Re: upgrade a user schema gdb after upgrading the master https://community.esri.com/t5/data-management-questions/upgrade-a-user-schema-gdb-after-upgrading-the/m-p/711078#M40272 <HTML><HEAD></HEAD><BODY><P>If you do not have "true" user-schema enterprise geodatabases then you are fine if you updated the SDE schema.</P><P></P><P><A class="link-titled" href="https://desktop.arcgis.com/en/arcmap/10.3/manage-data/gdbs-in-oracle/upgrade-user-schema-oracle.htm" title="https://desktop.arcgis.com/en/arcmap/10.3/manage-data/gdbs-in-oracle/upgrade-user-schema-oracle.htm">Upgrade a user-schema geodatabase—Help | ArcGIS Desktop</A>&nbsp;</P><P></P><P>You may want to also upgrade to a later release than 10.3.&nbsp;Support for 10.3.x will be retired on Dec. 1, 2020;&nbsp;<A class="link-titled" href="https://support.esri.com/en/Products/Desktop/arcgis-desktop/arcmap/10-3-1#product-support" title="https://support.esri.com/en/Products/Desktop/arcgis-desktop/arcmap/10-3-1#product-support">Esri Support ArcMap 10.3 (10.3.1)</A>&nbsp;</P></BODY></HTML> Thu, 28 May 2020 15:47:08 GMT https://community.esri.com/t5/data-management-questions/upgrade-a-user-schema-gdb-after-upgrading-the/m-p/711078#M40272 George_Thompson 2020-05-28T15:47:08Z Re: upgrade a user schema gdb after upgrading the master https://community.esri.com/t5/data-management-questions/upgrade-a-user-schema-gdb-after-upgrading-the/m-p/711079#M40273 <HTML><HEAD></HEAD><BODY><P>Hi George.</P><P>what does it mean by a "true" user schema.</P><P>I started upgrade from 10.0 to 10.7 so its required to upgrade to 10.3 first, so I'm affraid of upgrading&nbsp;from 10.3 to 10.7 with out upgrade the user schema.</P></BODY></HTML> Sat, 30 May 2020 15:09:15 GMT https://community.esri.com/t5/data-management-questions/upgrade-a-user-schema-gdb-after-upgrading-the/m-p/711079#M40273 RedaAli 2020-05-30T15:09:15Z Re: upgrade a user schema gdb after upgrading the master https://community.esri.com/t5/data-management-questions/upgrade-a-user-schema-gdb-after-upgrading-the/m-p/711080#M40274 <HTML><HEAD></HEAD><BODY><P>If you are not sure if you have what we call a user-schema geodatabase (<A class="link-titled" href="https://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-oracle/upgrade-user-schema-oracle.htm" title="https://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-oracle/upgrade-user-schema-oracle.htm">Upgrade a user-schema geodatabase—Geodatabases in Oracle | Documentation</A>&nbsp;) then you should be good after upgrading the SDE schema.</P><P></P><P>Based on your original screenshot, it looks like you only need to upgrade the SDE schema and you should be good.</P><P></P><P>Hope that helps!</P></BODY></HTML> Mon, 01 Jun 2020 11:00:36 GMT https://community.esri.com/t5/data-management-questions/upgrade-a-user-schema-gdb-after-upgrading-the/m-p/711080#M40274 George_Thompson 2020-06-01T11:00:36Z Re: upgrade a user schema gdb after upgrading the master https://community.esri.com/t5/data-management-questions/upgrade-a-user-schema-gdb-after-upgrading-the/m-p/711081#M40275 <HTML><HEAD></HEAD><BODY><P>Check the INSTANCES table to see if you have any entries;&nbsp;<A class="link-titled" href="https://resources.arcgis.com/en/help/main/10.2/#/Geodatabase_system_tables/002n0000008m000000/" title="https://resources.arcgis.com/en/help/main/10.2/#/Geodatabase_system_tables/002n0000008m000000/">ArcGIS Help (10.2, 10.2.1, and 10.2.2)</A>&nbsp;</P><P></P><P>That will tell you if you have user-schema geodatabases</P></BODY></HTML> Mon, 01 Jun 2020 12:24:10 GMT https://community.esri.com/t5/data-management-questions/upgrade-a-user-schema-gdb-after-upgrading-the/m-p/711081#M40275 George_Thompson 2020-06-01T12:24:10Z Re: upgrade a user schema gdb after upgrading the master https://community.esri.com/t5/data-management-questions/upgrade-a-user-schema-gdb-after-upgrading-the/m-p/711082#M40276 <HTML><HEAD></HEAD><BODY><P>Thank you !</P></BODY></HTML> Mon, 01 Jun 2020 14:56:51 GMT https://community.esri.com/t5/data-management-questions/upgrade-a-user-schema-gdb-after-upgrading-the/m-p/711082#M40276 RedaAli 2020-06-01T14:56:51Z