Re[2]: Writing a delay in PL/SQL?

2003-11-30 Thread Jonathan Gennick
Saturday, November 29, 2003, 10:44:26 PM, Khedr, Waleed ([EMAIL PROTECTED]) wrote: KW I'm curious why? some testing? Yes. Testing. I want a Data Pump job to run long enough for me to be able to play around in interactive mode from several different clients. I only have 28MB of data, and the load

Re: Re[2]: Writing a delay in PL/SQL?

2003-11-30 Thread Tanel Poder
Another way would have been to use not autoextending datafiles and resumable operations during data load... Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, November 30, 2003 4:54 PM Saturday, November 29, 2003, 10:44:26 PM, Khedr,

Re[2]: Writing a delay in PL/SQL?

2003-11-29 Thread Jonathan Gennick
Saturday, November 29, 2003, 8:59:34 PM, a whole bunch of people wrote: try DBMS_LOCK.SLEEP() Thanks all. I'll give that a try. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and