topic Re: Representation System Table in SDE Oracle in Data Management Questions https://community.esri.com/t5/data-management-questions/representation-system-table-in-sde-oracle/m-p/360393#M20664 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">Hi.<BR /><BR />I have a simple question.<BR /><BR />In ESRI Documentation about cartographic representation it says<BR /><BR /><BR /><BR />What's the name of this famous system table in ArcSDE in Oracle? So i can monitor where it stores the data.<BR /><BR />Greetings</BLOCKQUOTE><BR /><SPAN> </SPAN><BR /><SPAN>About this question i researched about the topic and i'll answer myself to share with everyone</SPAN><BR /><BR /><SPAN>The cartographic representation it's stored as XML data inside SDE system tables, specifically in an SDE_XML_DOC table defined as the DEFINITION Table.</SPAN><BR /><BR /><SPAN>The GDB_ITEMS table stores the registry of every item in SDE including cartographic representations. This table has 3 columns "Definition", "Documentation", "Iteminfo" which relates the GDB_ITEMS with SDE_XML_DOC Tables (using SDE_XML_COLUMNS table as intermediate).</SPAN><BR /><BR /><SPAN>So, if you create a new representation, the DBMS insert the registry on GDB_ITEMS table and a new definition in SDE_XML_DOC is created.</SPAN><BR /><BR /><SPAN>You can trace the representation data using the SDE_XML_ID in SDE_XML_DOC table related with DEFINITION column in GDB_ITEMS table and there you go, you have found your representation data.</SPAN></BODY></HTML> Fri, 07 Sep 2012 13:22:58 GMT Leandro-Zamudio 2012-09-07T13:22:58Z Representation System Table in SDE Oracle https://community.esri.com/t5/data-management-questions/representation-system-table-in-sde-oracle/m-p/360392#M20663 <HTML><HEAD></HEAD><BODY><SPAN>Hi.</SPAN><BR /><BR /><SPAN>I have a simple question.</SPAN><BR /><BR /><SPAN>In ESRI Documentation about cartographic representation it says</SPAN><BR /><BR /><BLOCKQUOTE class="jive-quote">Representations are a property of a feature class that are stored in system tables inside the geodatabase and in the feature class itself.</BLOCKQUOTE><BR /><BR /><SPAN>What's the name of this famous system table in ArcSDE in Oracle? So i can monitor where it stores the data.</SPAN><BR /><BR /><SPAN>Greetings</SPAN></BODY></HTML> Wed, 29 Aug 2012 20:07:44 GMT https://community.esri.com/t5/data-management-questions/representation-system-table-in-sde-oracle/m-p/360392#M20663 Leandro-Zamudio 2012-08-29T20:07:44Z Re: Representation System Table in SDE Oracle https://community.esri.com/t5/data-management-questions/representation-system-table-in-sde-oracle/m-p/360393#M20664 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">Hi.<BR /><BR />I have a simple question.<BR /><BR />In ESRI Documentation about cartographic representation it says<BR /><BR /><BR /><BR />What's the name of this famous system table in ArcSDE in Oracle? So i can monitor where it stores the data.<BR /><BR />Greetings</BLOCKQUOTE><BR /><SPAN> </SPAN><BR /><SPAN>About this question i researched about the topic and i'll answer myself to share with everyone</SPAN><BR /><BR /><SPAN>The cartographic representation it's stored as XML data inside SDE system tables, specifically in an SDE_XML_DOC table defined as the DEFINITION Table.</SPAN><BR /><BR /><SPAN>The GDB_ITEMS table stores the registry of every item in SDE including cartographic representations. This table has 3 columns "Definition", "Documentation", "Iteminfo" which relates the GDB_ITEMS with SDE_XML_DOC Tables (using SDE_XML_COLUMNS table as intermediate).</SPAN><BR /><BR /><SPAN>So, if you create a new representation, the DBMS insert the registry on GDB_ITEMS table and a new definition in SDE_XML_DOC is created.</SPAN><BR /><BR /><SPAN>You can trace the representation data using the SDE_XML_ID in SDE_XML_DOC table related with DEFINITION column in GDB_ITEMS table and there you go, you have found your representation data.</SPAN></BODY></HTML> Fri, 07 Sep 2012 13:22:58 GMT https://community.esri.com/t5/data-management-questions/representation-system-table-in-sde-oracle/m-p/360393#M20664 Leandro-Zamudio 2012-09-07T13:22:58Z