LAST_DDL_TIME Not Changing (Doc ID 1448241.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 22-Sep-2016***

Symptoms

On 10g, after recreating a package and a package body, it was noticed that the package body last_ddl_time did not change

For example:
SQL>select object_name,object_type,last_ddl_time from dba_objects;
my_pkg PACKAGE BODY 20111102 174237
my_pkg PACKAGE 20111111 140530


CREATE OR REPLACE PACKAGE test.my_pkg As ..
Package created.

CREATE OR REPLACE PACKAGE BODY test.my_pkg
Package body created.

GRANT EXECUTE ON test.my_pkg TO APP_ROLE
Grant succeeded.

GRANT EXECUTE ON test.PROXY_CARD_APImy_pkg TO PEDUSER
Grant succeeded.

SQL>select object_name,object_type,last_ddl_time from dba_objects;
 my_pkg PACKAGE BODY 20111102 174237
 my_pkg PACKAGE 20111111 165947

==> Package timestamp changes
==> Package body timestamp does not change

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms