Member Avatar for sillyboy

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.

  • 2 Contributors
  • 4 Replies
  • 100 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by sillyboy
Member Avatar for debasisdas

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

Member Avatar for sillyboy

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

Member Avatar for debasisdas

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

Member Avatar for sillyboy

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.