Does anybody know if oracle saves "last modified" data? I want to use this in a archiving tool by only querying for data after/before certain dates.

Recommended Answers

All 4 Replies

Please post your question clearly , what exactly is your requirment.

When you create tables, tubles, views whatever it may be, does Oracle keep track of the date/time this happens?

I does for DML opeartions. And status changes for DDL.

Care to shed some light on how I can obtain this information from the database?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.