Skip to content
June 4, 2015 / doganay

LAST_DDL_TIME ON DBA_OBJECTS NOT CHANGING

Let’s consider that you changed your sysdate to sysdate+1 on os level.
You created/compiled some objects, so you updated last_ddl_time of some objects to sysdate+1.
Then you set date back to sysdate.
Now you have sysdate+1 last_ddl_timed objects. When you compile them, you expect to change last_ddl_times
but they don’t. That’s because their last_ddl_times are greater than now.
So, of course you can drop and create objects to fix last_ddl_times but there is an easier way:

alter <object_type> <owner>.<object_name> compile plsql_code_type=interpreted;

You can also check:

SELECT * FROM DBA_PLSQL_OBJECT_SETTINGS;
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: