My Oracle Support Banner

LAST_DDL_TIME Not Changing (Doc ID 1448241.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.

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

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.