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

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

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

Other related posts: