O'Reilly logo

Applying and Extending Oracle Spatial by Siva Ravada, Simon Gerard Greener

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Logging changes independently of applications

Some spatial applications require that the old and new values in the schema be tracked so that the changes can be traced back in case of errors. For example, new surveying measurements from the field can be used to update the geometries for the existing land parcels, but the older values need to be tracked for a certain amount of time in the database in case of disputes. Oracle database provides an auditing technology called database auditing that can be used to monitor and track all database level actions. This auditing can be done for individual actions such as DML SQL statements or DDL SQL statements, or any other database level action. Database auditing is typically done to account for actions ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required