Old undocumented stuff – Recompiling with timestamp.

2

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 ;-)

Share.

About Author

Marco Gralike, working for AMIS Services BV as a Principal Oracle Database Consultant in the Netherlands, has experience as a DBA since 1994 (Oracle 6). Marco is also eager and skillful in other fields, like Operating System Administration and Application Servers, mainly to find working, performing solutions. Marco has been specializing in Oracle XMLDB, since 2003, focusing on his old love, database administration and performance. He is an Oracle XMLDB enthusiast ever since. He is also a dedicated contributor of the Oracle User Group community, helping people with their steep XMLDB learning curve. To this purpose, Marco also devoted his personal blog site to XMLDB and other Oracle issues. Marco is a member of the OakTable network and an Oracle ACE Director (specialization Oracle XMLDB).

2 Comments

  1. i guess this functionality is still needed for export/import, where probably the compile timestamp is set this way.