Old undocumented stuff – Recompiling with timestamp.

Marco Gralike 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 😉

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 😉

2 thoughts on “Old undocumented stuff – Recompiling with timestamp.

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

Comments are closed.

Next Post

Generating Matrix-Forms using ADF and JHeadstart - (Excel style)

Facebook0TwitterLinkedinOne of the long-standing challenges of application development – in any technology – is the Matrix Form: an updateable grid-like structure of rows, columns and cells. In this post I will show a way to build and even generate such a matrix form using ADF and JHeadstart (10.1.2). In this […]