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).
Igor
________________________________
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
something.
_________________________________________________________________
Search-Your way, your world, right now!
http://imagine-windowslive.com/minisites/searchlaunch/?locale=en-us&FORM
=WLMTAG
--
//www.freelists.org/webpage/oracle-l
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Other related posts:
