Re: When a Column/Field was Added to a Table

From: <>
Date: Fri, 7 Nov 2008 06:24:16 -0800 (PST)
Message-ID: <>

On Nov 7, 7:18 am, gazzag <> wrote:
> On 6 Nov, 20:41, wrote:
> > I'm trying to create a report that will tell me what new fields are
> > added to a database by software patches. I'd like to be able to run
> > the report after applying the patches, and have the report give me the
> > new fields that were added. Does Oracle store the date that a new
> > column was added to a table? Thanks in advance.
> Look into the LAST_DDL_TIME column in the DBA_OBJECTS view.
> -g

That will give me a Table that is added, with the date it was created, but it doesn't show new fields that are added to a table. Received on Fri Nov 07 2008 - 08:24:16 CST

Original text of this message