Changes to VERSIONS, STATE_LINEAGES, MVTABLES_MODIFIED tables in ArcSDE 10

569
3
Jump to solution
03-06-2013 05:03 PM
SendhilKolandaivel
New Contributor
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
Reply
0 Kudos
1 Solution

Accepted Solutions
RussellBrennan
Esri Contributor
Those tables were not part of the changes.

View solution in original post

Reply
0 Kudos
3 Replies
RussellBrennan
Esri Contributor
Those tables were not part of the changes.

View solution in original post

Reply
0 Kudos
AsrujitSengupta
Regular Contributor III
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,
Reply
0 Kudos
SendhilKolandaivel
New Contributor
Glad to hear that these tables were not modified!

Thanks Russell!

Thanks for the link to the System Tables Asrujit!

Sendhil
Reply
0 Kudos