Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

LAST_DDL_TIME, and TIMESTAMP in the USER_OBJECTS

421658May 19 2004 — edited May 19 2004
Hi,

I need to know the difference between the LAST_DDL_TIME, and TIMESTAMP in the USER_OBJECTS table concerning with the packages.I know both will give the latest compile time of the package , but i need to know why there is two seperate column. I also could find the date and time of LAST_DDL_TIME, TIMESTAMP to be different some time for a particular pacakge. Please help me in understanding the difference in detail.

Regards,
Vijayanand.C
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 16 2004
Added on May 19 2004
1 comment
2,881 views