TransWikia.com

Get the date a feature class was last modified using SQL?

Geographic Information Systems Asked by MapMan on March 22, 2021

I have an oracle database that contains versioned and non versioned feature classes.

Each feature class has editor tracking enabled, so when a feature is added or updated, I can see the date the change occurred, and from that can calculate the maxdate of that featureclass to get when it was last "modified".
However if a feature is deleted that information is not captured within the featureclass (therefore the last modified date will be incorrect). I know that if it is versioned the OBJECTID is captured in the deletes table, but there is no date field (that i am aware of).

Is there a SQL way of getting the last modified date of a feature class, whether it is versioned or non versioned and regardless of whether it is an insert, update or delete.

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP