topic A script referencing sde.gdb_items_vw gives ORA-00942: table or view does not exist in Data Management Questions https://community.esri.com/t5/data-management-questions/a-script-referencing-sde-gdb-items-vw-gives-ora/m-p/378998#M21551 <HTML><HEAD></HEAD><BODY><SPAN>Hi there</SPAN><BR /><BR /><SPAN>I am trying to locate which fields domains are being used by. I am using ArcMap 10.1 but accessing a 9.3.1 geodatabase stored in an Oracle 10.2g database,</SPAN><BR /><BR /><SPAN>There was a a script on the following page:</SPAN><BR /><A href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//006z000000t9000000">http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//006z000000t9000000</A><BR /><BR /><SPAN>However when ever I run it I get the error:</SPAN><BR /><SPAN>ORA-00942: table or view does not exist</SPAN><BR /><SPAN>00942. 00000 -&nbsp; "table or view does not exist"</SPAN><BR /><BR /><SPAN>It is for the table sde.gdb_items_vw which does not exist. Would anyone happen to know why it might not exist?</SPAN><BR /><BR /><SPAN>I am trying to delete a domain but before I can do so, I need to remove it from a field but I need to see which field(s) are still referencing it.</SPAN><BR /><BR /><SPAN>Kind regards</SPAN><BR /><BR /><BR /><SPAN>Tim</SPAN></BODY></HTML> Fri, 22 Mar 2013 13:29:47 GMT TimLangner 2013-03-22T13:29:47Z A script referencing sde.gdb_items_vw gives ORA-00942: table or view does not exist https://community.esri.com/t5/data-management-questions/a-script-referencing-sde-gdb-items-vw-gives-ora/m-p/378998#M21551 <HTML><HEAD></HEAD><BODY><SPAN>Hi there</SPAN><BR /><BR /><SPAN>I am trying to locate which fields domains are being used by. I am using ArcMap 10.1 but accessing a 9.3.1 geodatabase stored in an Oracle 10.2g database,</SPAN><BR /><BR /><SPAN>There was a a script on the following page:</SPAN><BR /><A href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//006z000000t9000000">http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//006z000000t9000000</A><BR /><BR /><SPAN>However when ever I run it I get the error:</SPAN><BR /><SPAN>ORA-00942: table or view does not exist</SPAN><BR /><SPAN>00942. 00000 -&nbsp; "table or view does not exist"</SPAN><BR /><BR /><SPAN>It is for the table sde.gdb_items_vw which does not exist. Would anyone happen to know why it might not exist?</SPAN><BR /><BR /><SPAN>I am trying to delete a domain but before I can do so, I need to remove it from a field but I need to see which field(s) are still referencing it.</SPAN><BR /><BR /><SPAN>Kind regards</SPAN><BR /><BR /><BR /><SPAN>Tim</SPAN></BODY></HTML> Fri, 22 Mar 2013 13:29:47 GMT https://community.esri.com/t5/data-management-questions/a-script-referencing-sde-gdb-items-vw-gives-ora/m-p/378998#M21551 TimLangner 2013-03-22T13:29:47Z Re: A script referencing sde.gdb_items_vw gives ORA-00942: table or view does not exi https://community.esri.com/t5/data-management-questions/a-script-referencing-sde-gdb-items-vw-gives-ora/m-p/378999#M21552 <HTML><HEAD></HEAD><BODY><SPAN>That script assumes 10.x geodatabase; 9.3.1 doesn't have the same organization.</SPAN><BR /><BR /><SPAN>- V</SPAN></BODY></HTML> Fri, 22 Mar 2013 13:48:32 GMT https://community.esri.com/t5/data-management-questions/a-script-referencing-sde-gdb-items-vw-gives-ora/m-p/378999#M21552 VinceAngelo 2013-03-22T13:48:32Z Re: A script referencing sde.gdb_items_vw gives ORA-00942: table or view does not exi https://community.esri.com/t5/data-management-questions/a-script-referencing-sde-gdb-items-vw-gives-ora/m-p/379000#M21553 <HTML><HEAD></HEAD><BODY><SPAN>Thanks for pointing that out </SPAN><SPAN style="color: #3E3E3E; font-family: Arial;">Vangelo.<BR /><BR />Is their a list of tables used in 9.3.1 or even a comparison chart which shows the table name differences between version side by side?<BR /><BR />Kind regards<BR /><BR />Tim</SPAN></BODY></HTML> Mon, 25 Mar 2013 13:27:14 GMT https://community.esri.com/t5/data-management-questions/a-script-referencing-sde-gdb-items-vw-gives-ora/m-p/379000#M21553 TimLangner 2013-03-25T13:27:14Z Re: A script referencing sde.gdb_items_vw gives ORA-00942: table or view does not exi https://community.esri.com/t5/data-management-questions/a-script-referencing-sde-gdb-items-vw-gives-ora/m-p/379001#M21554 <HTML><HEAD></HEAD><BODY><SPAN>The geodatabase table structures are documented in each release.&nbsp; The changes</SPAN><BR /><SPAN>at 10.0 were highlighted in "What's New" pages and multiple other forms during</SPAN><BR /><SPAN>10.0 rollout.&nbsp; There is no table comparison between 9.x and 10.x though, since</SPAN><BR /><SPAN>the strucutre is so radically different (the relationships are now stored in XML).</SPAN><BR /><BR /><SPAN>- V</SPAN></BODY></HTML> Mon, 25 Mar 2013 15:17:21 GMT https://community.esri.com/t5/data-management-questions/a-script-referencing-sde-gdb-items-vw-gives-ora/m-p/379001#M21554 VinceAngelo 2013-03-25T15:17:21Z Re: A script referencing sde.gdb_items_vw gives ORA-00942: table or view does not exi https://community.esri.com/t5/data-management-questions/a-script-referencing-sde-gdb-items-vw-gives-ora/m-p/379002#M21555 <HTML><HEAD></HEAD><BODY><SPAN>Thank you for that. I will look through the What's new sections.</SPAN></BODY></HTML> Tue, 26 Mar 2013 09:42:41 GMT https://community.esri.com/t5/data-management-questions/a-script-referencing-sde-gdb-items-vw-gives-ora/m-p/379002#M21555 TimLangner 2013-03-26T09:42:41Z