Home » SQL & PL/SQL » SQL & PL/SQL » how to know the time of creation of column
how to know the time of creation of column [message #241793] Wed, 30 May 2007 11:33 Go to next message
rolex.mp
Messages: 161
Registered: February 2007
Senior Member
how can I get the details about when a column in a table has been created ?

any data dictionary table which provides this info ?
Re: how to know the time of creation of column [message #241796 is a reply to message #241793] Wed, 30 May 2007 11:38 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Sorry, Oracle doesn't store column creation time at all.

PS: Looks like SYS.COL$(SPARE6) may be used for this in future.
Re: how to know the time of creation of column [message #241797 is a reply to message #241793] Wed, 30 May 2007 11:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, you only have the last DDL time on the table (and adding a column is a DDL) but no time for a specific column.

Regards
Michel
Re: how to know the time of creation of column [message #241799 is a reply to message #241793] Wed, 30 May 2007 11:42 Go to previous messageGo to next message
rolex.mp
Messages: 161
Registered: February 2007
Senior Member
so from which table can i get the DDL statements details ?
Re: how to know the time of creation of column [message #241803 is a reply to message #241793] Wed, 30 May 2007 11:44 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
>how can I get the details about when a column in a table has been created ?
LOGMINER could provide the details.
Re: how to know the time of creation of column [message #241813 is a reply to message #241793] Wed, 30 May 2007 11:56 Go to previous messageGo to next message
rolex.mp
Messages: 161
Registered: February 2007
Senior Member
can i know which procedure specifies the the data inside the package ?
also let me know whether any parameter has to be set in init.ora to get these details ?
Re: how to know the time of creation of column [message #241815 is a reply to message #241799] Wed, 30 May 2007 11:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You mean the DDL of table creation?
Use dbms_metadata.get_ddl function.

Regards
Michel
Re: how to know the time of creation of column [message #241817 is a reply to message #241813] Wed, 30 May 2007 11:59 Go to previous message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
can i know which procedure specifies the the data inside the package ?

What does this mean? Can you explain?
Do you want the source of a package?

Regards
Michel
Previous Topic: Refrential Integrity Query
Next Topic: query
Goto Forum:
  


Current Time: Tue Dec 06 08:29:49 CST 2016

Total time taken to generate the page: 0.09268 seconds