Erman Arslan's Oracle Forum
›
Database
Login
Register
Search
everywhere
only in this topic
Advanced Search
When last time DB objects was accessed/ modified
Classic
List
Threaded
♦
♦
Locked
2 messages
Options
Loading...
Subscribe via email
Move topic
Pin topic
Unpin topic
Lock topic
Unlock topic
Delete this topic
Delete this topic
Change title and meta tags
Embed post
Permalink
Zaheer
Reply
|
Threaded
Open this post in threaded view
♦
♦
|
More
Loading...
Reply to author
Edit post
Move post
Delete this post
Delete this post and replies
Change post date
Print post
Permalink
Raw mail
Sep 30, 2020; 7:39am
When last time DB objects was accessed/ modified
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
ErmanArslansOracleBlog
Reply
|
Threaded
Open this post in threaded view
♦
♦
|
More
Loading...
Reply to author
Edit post
Move post
Delete this post
Delete this post and replies
Change post date
Print post
Permalink
Raw mail
Sep 30, 2020; 12:19pm
Re: When last time DB objects was accessed/ modified
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.
Free forum by Nabble
Edit this page