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