topic Re: Changes to VERSIONS, STATE_LINEAGES, MVTABLES_MODIFIED tables in ArcSDE 10 in Data Management Questions

Changes to VERSIONS, STATE_LINEAGES, MVTABLES_MODIFIED tables in ArcSDE 10

SendhilKolandaivel — Thu, 07 Mar 2013 01:03:40 GMT

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

Re: Changes to VERSIONS, STATE_LINEAGES, MVTABLES_MODIFIED tables in ArcSDE 10

RussellBrennan — Thu, 07 Mar 2013 15:04:03 GMT

Those tables were not part of the changes.

Re: Changes to VERSIONS, STATE_LINEAGES, MVTABLES_MODIFIED tables in ArcSDE 10

AsrujitSengupta — Thu, 07 Mar 2013 15:33:57 GMT

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,

Re: Changes to VERSIONS, STATE_LINEAGES, MVTABLES_MODIFIED tables in ArcSDE 10

SendhilKolandaivel — Thu, 07 Mar 2013 16:30:43 GMT

Glad to hear that these tables were not modified!

Thanks Russell!

Thanks for the link to the System Tables Asrujit!

Sendhil