Re: Date when column added?

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: cemail_219@xxxxxxxxxxx
  • Date: Tue, 26 Sep 2006 11:45:17 -0700

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!


Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: