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 😉

0 0
Read Time:48 Second

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 😉

About Post Author

Marco Gralike

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).
Happy
Happy
0 %
Sad
Sad
0 %
Excited
Excited
0 %
Sleepy
Sleepy
0 %
Angry
Angry
0 %
Surprise
Surprise
0 %

Average Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

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)

One 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 […]
%d bloggers like this: