RE: Date when column added?

In 10i it's not populated either.  

One option, if you are lucky and your new column has "NOT NULL" constraint (add column, populate column, make it "NOT NULL"), then you could look at LAST_CHANGE column in dba_constraint to find out at least when "NOT NULL" constraint was added (which could be close to the time when new column was added).  

Igor

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still Sent: Tuesday, September 26, 2006 2:45 PM To: cemail_219_at_hotmail.com
Cc: oracle-l_at_freelists.org
Subject: Re: Date when column added?

Look at sys.obj$

That stores various dates for modify/create/analyze, etc of objects. Columns are not considered objects, and not recorded there.

Look at sys.col$. There is one date column there, but it does not appear to be populated, at least on the 9i database I checked.

On 9/26/06, J. Dex <cemail_219_at_hotmail.com > wrote:

        How can I tell when a particular column was added to a table? I was looking

        for a DBA_view that would tell me but I must be missing something.                  

        Search-Your way, your world, right now!         

http://imagine-windowslive.com/minisites/searchlaunch/?locale=en-us&FORM =WLMTAG         

	--
	http://www.freelists.org/webpage/oracle-l
	
	
	

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist


--
http://www.freelists.org/webpage/oracle-l