Re: Export taking too long in hp server/Ora 7.0.16

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 24 Nov 1999 20:50:32 +0800
Message-ID: <383BDF18.805@yahoo.com>

duraisingh wrote:
>
> Hellow Guru's
> In one of our database server (oracle 7.0.16/HP 9)
> All of a sudden the export is taking too long to complete.
> The database size is around 7gb.
> previously it took only 3 hours to complete.
> Is there any workaround. Suggessions are always welcome.
> Is there anything I have to look for.
> TIA.
> John Durai

Enlarge the buffer, and if you can move to 7.2+ you can add direct=true which will make your exports scream along...

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Wed Nov 24 1999 - 06:50:32 CST