OraFAQ Forum: Server Administration » Scripts to check object's last modified date

Home » RDBMS Server » Server Administration » Scripts to check object's last modified date

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Scripts to check object's last modified date [message #231957]

Wed, 18 April 2007 23:07

*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.

Report message to a moderator

Re: Scripts to check object's last modified date [message #231959 is a reply to message #231957]

Wed, 18 April 2007 23:10

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: Scripts to check object's last modified date [message #231961 is a reply to message #231957]

Wed, 18 April 2007 23:20

*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.

Report message to a moderator

Re: Scripts to check object's last modified date [message #231963 is a reply to message #231957]

Wed, 18 April 2007 23:22

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

SQL> DESC USER_OBJECTS

Report message to a moderator

Re: Scripts to check object's last modified date [message #231987 is a reply to message #231963]

Thu, 19 April 2007 00:42

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

Report message to a moderator

Previous Topic:	Installation of Oracle 10g on NAS
Next Topic:	strange problem in droping a single table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 11:28:36 CST 2024