Erman Arslan's Oracle Forum › Database

When last time DB objects was accessed/ modified

Classic

List

Threaded

2 messages Options

Zaheer

When last time DB objects was accessed/ modified

Dear Erman,

I need to know when objects in my database accessed or modified last time. I need to know the timestamp.

Pl guide me on this.

Thanks & Regards

ErmanArslansOracleBlog

Re: When last time DB objects was accessed/ modified

Administrator

You can use ORA_ROWSCN to find the Last Modified Date of a Table in Oracle.
Check internet, there are several examples of using it.