Login  Register

When last time DB objects was accessed/ modified

classic Classic list List threaded Threaded
2 messages Options Options
Embed post
Permalink
Reply | Threaded
Open this post in threaded view
| More
Print post
Permalink

When last time DB objects was accessed/ modified

Zaheer
21 posts
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
Reply | Threaded
Open this post in threaded view
| More
Print post
Permalink

Re: When last time DB objects was accessed/ modified

ErmanArslansOracleBlog
Administrator
5727 posts
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.