RE: Date when column added?

  • From: "Igor Neyman" <ineyman@xxxxxxxxxxxxxx>
  • To: <jkstill@xxxxxxxxx>, <cemail_219@xxxxxxxxxxx>
  • Date: Tue, 26 Sep 2006 14:57:25 -0400

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).


From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jared Still
Sent: Tuesday, September 26, 2006 2:45 PM
To: cemail_219@xxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxx > 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
        Search-Your way, your world, right now!

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: