Re: Oracle data dictionary - Can I obtain object create/alter timestamp?

From: Enzo Maini <touringcarclub_at_hotmail.com>
Date: Mon, 14 Oct 2002 02:26:13 GMT
Message-ID: <9Xpq9.31576$lV3.2577107@newsread1.prod.itd.earthlink.net>

Oracle 9i has a change management package.

Oracle 8i does not.

If you mess the dd tables Oracle support will not help you in case of a major crash plus you will have problems during an upgrade.

With version 6, 7, 8 and 8i I created my own Pro*C program in Unix and C++ in Windows and all object scripts went through that program and that program would update my own version control tables for the database.

Other than that there third party database design tools that will do this for you.

"Alex Blyth" <alex_blyth_at_amp.com.au> wrote in message news:7ae9eb69.0210131704.6d1e6a11_at_posting.google.com...
> Hi All
>
> I am interested in obtaining the creation/last altered date/time for a
> user column or table from the Oracle (8i - 8.1.7) data dictionary. I
> thought of using a table such as COL$ but it doesn't contain the
> desired info.
>
> Is there a view or another table I could join to to obtain this info?
> Or, am I asking for more than Oracle think I need to know?
>
> Any help would be greatly appreciated.
>
> Thanks
>
> Alex
Received on Sun Oct 13 2002 - 21:26:13 CDT