Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Date when column added?

Re: Date when column added?

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 26 Sep 2006 11:45:17 -0700
Message-ID: <bf46380609261145xd8392e8tf31f30ba46302d23@mail.gmail.com>


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
Received on Tue Sep 26 2006 - 13:45:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US