Yesterday i was reading nice discussions on Asktom about the dual table. Afterwards somehow a “undocumented” Oracle feature popped into my mind again. Last time I used is at least in those days I worked with Oracle 7.0 /7.1. So I tried It out on Oracle database version 10.1.0.4 and it still works 😉
Maybe it is (still) usefull to someone. See hence my example:
SQL> drop procedure marco Procedure dropped. SQL> create procedure marco 2 as 3 begin 4 null; 5 end; 6 / Procedure created. SQL> select timestamp 2 from user_objects 3 where object_name = 'MARCO'; TIMESTAMP ------------------- 2005-05-12:18:14:56 SQL> alter procedure marco compile timestamp '2005-01-17:15:32:17'; Procedure altered. SQL> select timestamp 2 from user_objects 3 where object_name = 'MARCO'; TIMESTAMP ------------------- 2005-01-17:15:32:17
Btw Tom has also a very nice “The Tom Kyte Blog” site…but you probably knew that 😉
It was in the old days 😉
i guess this functionality is still needed for export/import, where probably the compile timestamp is set this way.