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!
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:
