Home » RDBMS Server » Server Administration » Scripts to check object's last modified date
Scripts to check object's last modified date [message #231957] Wed, 18 April 2007 23:07 Go to next message
*Jess*
Messages: 48
Registered: December 2005
Location: Penang, Malaysia
Member

Hi,

Is there any scripts to check objects (index, table..etc) last modification date?

Thanks.
Re: Scripts to check object's last modified date [message #231959 is a reply to message #231957] Wed, 18 April 2007 23:10 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>Is there any scripts to check objects (index, table..etc) last modification date?
Please define "last modification date"?
SQL> DESC USER_OBJECTS
Re: Scripts to check object's last modified date [message #231961 is a reply to message #231957] Wed, 18 April 2007 23:20 Go to previous messageGo to next message
*Jess*
Messages: 48
Registered: December 2005
Location: Penang, Malaysia
Member

Thanks for the reply.

I would want to check whether the object is being modified. Would want to know whether developers change their coding for some of the tables.

Re: Scripts to check object's last modified date [message #231963 is a reply to message #231957] Wed, 18 April 2007 23:22 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
SQL> DESC USER_OBJECTS
Re: Scripts to check object's last modified date [message #231987 is a reply to message #231963] Thu, 19 April 2007 00:42 Go to previous message
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
Senior Member

I Dont think it is possible unless the FGA { Audit } is ON in the database.

-Sai Jeedigunta
Previous Topic: Installation of Oracle 10g on NAS
Next Topic: strange problem in droping a single table
Goto Forum:
  


Current Time: Sun Dec 04 10:18:21 CST 2016

Total time taken to generate the page: 0.08192 seconds