Home » SQL & PL/SQL » SQL & PL/SQL » table creation date
table creation date [message #265249] Wed, 05 September 2007 22:23 Go to next message
alister
Messages: 101
Registered: August 2007
Location: India
Senior Member
Is there a way by which I can know when a particular table was created and when it was last modified.

Alister
Re: table creation date [message #265250 is a reply to message #265249] Wed, 05 September 2007 22:34 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
DBA|ALL|USER_OBJECTS
Re: table creation date [message #265251 is a reply to message #265249] Wed, 05 September 2007 22:37 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Select created from all_objects where object_type='TABLE';
Re: table creation date [message #265474 is a reply to message #265249] Thu, 06 September 2007 07:11 Go to previous messageGo to next message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
For last modified date, column LAST_DDL_TIME of all_objects,dba_objects,user_objects table

[Updated on: Thu, 06 September 2007 07:12]

Report message to a moderator

Re: table creation date [message #265485 is a reply to message #265474] Thu, 06 September 2007 07:24 Go to previous messageGo to next message
psiva_oracle
Messages: 25
Registered: August 2007
Location: india
Junior Member
Hi,

You can use the below query for identify the table created date and table last modified date.

Select object_name,created,last_ddl_time,timestamp from all_objects where object_type='TABLE';

Thanks,
Siva.P
Bangalore.
Re: table creation date [message #265488 is a reply to message #265485] Thu, 06 September 2007 07:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Anyone to add a new column from this view?

Regards
Michel
Re: table creation date [message #265497 is a reply to message #265488] Thu, 06 September 2007 07:41 Go to previous messageGo to next message
psiva_oracle
Messages: 25
Registered: August 2007
Location: india
Junior Member
No Michel, You can't add a new column in View.

View is the shadow / Window of the Table. whatever is there in Table just reflecting in View.

Thanks,
Siva.P
Bangalore
Re: table creation date [message #265503 is a reply to message #265497] Thu, 06 September 2007 08:14 Go to previous message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
You missed Michel's tongue in cheek response. Good one Michel.
Previous Topic: view
Next Topic: ORA-00917 error
Goto Forum:
  


Current Time: Sun Dec 04 19:09:49 CST 2016

Total time taken to generate the page: 0.07115 seconds