Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: pragma TIMESTAMP('2000-06-22:11:21:00')

Re: pragma TIMESTAMP('2000-06-22:11:21:00')

From: Stephane Faroult <sfaroult_at_roughsea.com>
Date: Mon, 03 Apr 2006 18:18:07 +0200
Message-ID: <44314ABF.4080701@roughsea.com>


Krishan,

     I suspect that it is a trick used by Oracle utilities (such as exp/imp) to preserve the creation or last modification date and avoid intempestive invalidation and recompiling.

HTH Stéphane Faroult

Krishan Gupta wrote:

> Hello List,
>
>
>
> This may be a silly question, but I would like to know about what does
> *pragma TIMESTAMP* in pl/sql procedure or packge controls. I googled
> it but no luck. I would appreciate any info (your comments, links)
> regardiong this.
>
>
>
> TIA
>
> Krishan
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Apr 03 2006 - 11:18:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US