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

From: ddf <>
Date: Fri, 7 Nov 2008 07:04:21 -0800 (PST)
Message-ID: <>

On Nov 6, 2:41 pm, 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.

No, it only stores the date of the most recent DDL, regardless of what that DDL statement did. You'll probably need to write an after DDL trigger to populate yet another table to list the changes made to a given applicaiton table.

David Fitzjarrell Received on Fri Nov 07 2008 - 09:04:21 CST

Original text of this message