Home » RDBMS Server » Server Administration » Tracking table creation (oracle 9i)
Tracking table creation [message #353745] Tue, 14 October 2008 23:42 Go to next message
mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai
Senior Member


How to find out when a table was created/altered and what alteration are made to a table.

kanish
Re: Tracking table creation [message #353749 is a reply to message #353745] Wed, 15 October 2008 00:00 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Last ddl time by,
select LAST_DDL_TIME from dba_objects where object_name='&table_name';


To know what alter,
You have to audit or
use logminer.
Re: Tracking table creation [message #353755 is a reply to message #353749] Wed, 15 October 2008 00:42 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
...or a DDL trigger.

Regards
Michel
Previous Topic: Memory Issue on Oracle Server
Next Topic: what is server PSEUDO?
Goto Forum:
  


Current Time: Wed Dec 04 19:15:28 CST 2024