OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » when table altered?

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

when table altered? [message #262908]

Tue, 28 August 2007 08:38

tarikcorut
Messages: 2
Registered: August 2007

Junior Member

hi,
i need to know the list of tables in my oracle database, and want to see when these tables altered last or added index or removed index. Also i want to see which user changed this table in which machine. How can make these?
Anyone can help me for that.
Thanks.

Report message to a moderator

Re: when table altered? [message #262914 is a reply to message #262908]

Tue, 28 August 2007 08:43

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

i need to know the list of tables in my oracle database,

select table_name 
from dba_tables
where owner = '&USERNAME';

and want to see when these tables altered last or added index or removed index. Also i want to see which user changed this table in which machine. How can make these?

Enable auditing options.

http://download.oracle.com/docs/cd/B14117_01/server.101/b10743/security.htm#sthref2907

Regards
Taj

Report message to a moderator

Re: when table altered? [message #262916 is a reply to message #262914]

Tue, 28 August 2007 08:44

tarikcorut
Messages: 2
Registered: August 2007

Junior Member

thanks

Report message to a moderator

Previous Topic:	upgrading to 10g
Next Topic:	Number of connections

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 06:35:27 CST 2024