Representation System Table in SDE Oracle

[Leandro-Zamudio]

Hi.

I have a simple question.

In ESRI Documentation about cartographic representation it says

Representations are a property of a feature class that are stored in system tables inside the geodatabase and in the feature class itself.

What's the name of this famous system table in ArcSDE in Oracle? So i can monitor where it stores the data.

Greetings

[Leandro-Zamudio · Accepted solution]

Hi.

I have a simple question.

In ESRI Documentation about cartographic representation it says



What's the name of this famous system table in ArcSDE in Oracle? So i can monitor where it stores the data.

Greetings

About this question i researched about the topic and i'll answer myself to share with everyone

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.

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).

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.

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.