Fwd: I want a suggestion for data transfer

2001-02-24 Thread kumar iyer
Note: forwarded message attached. __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ Hi! I need a suggestion for my problem. I have an Oracle 8i database on Windows NT and a front end application

Re: Truncate in a procedure?

2001-02-24 Thread Bryan Sirtosky
For Oracle 8.1.6, I have a few packages in which I have procedures which issue the following statement: EXECUTE IMMEDIATE 'TRUNCATE TABLE table_name'; The statement is usually issued in connection with wiping out any old report contents from a table when a new report is requested. The

RE: I want a suggestion for data transfer

2001-02-24 Thread Jyoti
If the customer needs read only information, one thought is to have a standby database which is kept in read only mode during the required time and recover during the off peak time. -Original Message- Sent: Friday, February 23, 2001 9:11 PM To: Multiple recipients of list ORACLE-L Hi!

Re: RE: Oracle 8i On solaris

2001-02-24 Thread Cyril Thankappan
but hey!!! is an ICG available for Oracle 8i on Solaris 10??? " am about to install Oracle 8i Enterprise on Sun Solaris version 10." Please let me know more about Solaris 10! - Original Message -- Diana Duncan [EMAIL PROTECTED] wrote: To:Multiple recipients of

Re: RE: Mailing frm Oracle

2001-02-24 Thread Anjali R
I also had same problem before, but dbms_job.broken procedure takes care of it. I first broke the job and then removed it. It works. Regs, - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Friday, February 23, 2001 5:11 AM one caution: If