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

Report message to a moderator

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.

Report message to a moderator

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: 68666
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
...or a DDL trigger.

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jul 07 23:38:44 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.