In Oracle9i, Oracle also needs to recompile the process even if a completely identical process is rebuilt, as can be seen from the Last_ddl_time:
[Oracle@jumper oracle]$ Sqlplus Eygle/eygle
Sql*plus:release 9.2.0.4.0-production on Sat Mar 31 17:52:55 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0-production
With the partitioning option
Jserver Release 9.2.0.4.0-production
sql> Create or replace PROCEDURE pining
2 is
3 BEGIN
4 NULL;
5 end;
6/
Procedure created.
Sql> Select Object_name,last_ddl_time from dba_objects where object_name= ' pining ';
object_name Last_ddl_time
------------------------------ -------------------
Pining 2007-03-31 17:52:58
sql> Create or replace PROCEDURE pining
2 is
3 BEGIN
4 NULL;
5 end;
6/
Procedure created.
Sql> Select Object_name,last_ddl_time from dba_objects where object_name= ' pining ';
object_name Last_ddl_time
------------------------------ -------------------
Pining 2007-03-31 17:54:35