OraFAQ Forum: Server Administration » Creation date of table

Home » RDBMS Server » Server Administration » Creation date of table

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

Creation date of table [message #132954]

Wed, 17 August 2005 00:45

sarfraz_attari
Messages: 123
Registered: July 2005

Senior Member

Is there any way to find out creation date of table in any schema
is there any table which is storing creation and updation date of table

thanks
sarfraz

Report message to a moderator

Re: Creation date of table [message #132986 is a reply to message #132954]

Wed, 17 August 2005 03:24

JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland

Senior Member

Look at the all_objects table

HTH
Jim

Report message to a moderator

Re: Creation date of table [message #132991 is a reply to message #132986]

Wed, 17 August 2005 03:30

sarfraz_attari
Messages: 123
Registered: July 2005

Senior Member

thanks

Report message to a moderator

Re: Creation date of table [message #132992 is a reply to message #132991]

Wed, 17 August 2005 03:39

JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland

Senior Member

If you run the query:

SELECT TABLE_NAME, COLUMN_NAME, COMMENTS
FROM DICT_COLUMNS
WHERE COLUMN_NAME LIKE '%&COLUMN%'

Then at the prompt enter text that the column might contain e.g. cache, it will give you a list of possibilites.

HTH
Jim

Report message to a moderator

Previous Topic:	How to Make two Databases Equal...Some body help me
Next Topic:	Reg. session in trace file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 26 10:13:10 CST 2025