Re: Full export takes too long

Leng, There is a couple of things to consider. 1. add a buffer= statement to your export command. By not specifying one you get the default which may be very small on your OS. We use buffer=2000000 for our exports to disk. 2. look into doing multiple exports at the same time if you have a multi processor system. One approach would be export by owner.

HTH Chuck
>
> Hello everyone,
>
> Had a good Christmas? While everyone was enjoying themselves, I had a
> control file to rebuild. Such is life of a dba...
>
> Reached maxdatafiles (default of 32 on VMS) you see. So had to recreate the
> control file. Just to be on the safe side, I did a full database export so
> that if worse comes to worse, I'd be able to recreate the database and
> import. The full database export of a 5.5gig database took 7 hours!! The
> control file recreation process itself took half an hour. And so far, the
> database looks stable (touch wood).
>
> Command: exp / log=myexp.log full=y compress=y grants=y indexes=y rows=y
>
> If it took 7 hours for a 5.5, it'll take more than 2 days to export our 20+
> gig database! So I'd like some tips on how to quicken this process.
>
> Env: VAX VMS 6.1, Oracle 7.1.3, Archive log mode
>
> TIA,
> Leng.
>
> --------------------------------------------
> Leng Kaing
> DBA - Directory Technology P/L
> Tel: +61-3-9892-9081 Fax: +61-3-9892-9344
> Email: lkaing_at_ventnds1.telecom.com.au
> WWW : http://www.vut.edu.au/~leng/oracle/voug.html
>
Received on Thu Dec 28 1995 - 09:54:22 CST