Changes to VERSIONS, STATE_LINEAGES, MVTABLES_MODIFIED tables in ArcSDE 10

[SendhilKolandaivel]

Hi,

I am in the process of writing a python script that generates a summary of number of inserts, updates and deletes for every feature class updated in every version in the GDB.  We intend to use this as part of our QC efforts, as we have student interns who help with the data updates.

The script does this by querying the following tables:

• SDE.VERSIONS


• SDE.STATE_LINEAGES


• SDE.MVTABLES_MODIFIED


• SDE.TABLE_REGISTRY


• SDE.A/D TABLES

We are running ArcSDE 9.3 on Oracle 10g, and hope to upgrade to ArcSDE 10.1 in the near future.

I remember reading that some of the back-end SDE system tables have changed in 10, and am wondering if any of these tables were part of that change.

Thanks,

Sendhil

[RussellBrennan · Accepted solution]

Those tables were not part of the changes.

[AsrujitSengupta]

Sendhil,

You can refer to the below link for a list of all the system tables in 10.1 Oracle gdb:

System tables of a geodatabase stored in Oracle
http://resources.arcgis.com/en/help/main/10.1/index.html#//002n0000008m000000

Regards,

[SendhilKolandaivel]

Glad to hear that these tables were not modified!

Thanks Russell!

Thanks for the link to the System Tables Asrujit!

Sendhil