Home » RDBMS Server » Server Administration » when table altered?
when table altered? [message #262908] Tue, 28 August 2007 08:38 Go to next message
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.
Re: when table altered? [message #262914 is a reply to message #262908] Tue, 28 August 2007 08:43 Go to previous messageGo to next message
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
Re: when table altered? [message #262916 is a reply to message #262914] Tue, 28 August 2007 08:44 Go to previous message
tarikcorut
Messages: 2
Registered: August 2007
Junior Member
thanks
Previous Topic: upgrading to 10g
Next Topic: Number of connections
Goto Forum:
  


Current Time: Wed Dec 07 18:57:55 CST 2016

Total time taken to generate the page: 0.09885 seconds