Re: HELP ! Export takes more than 8 hours !!

On Fri, 01 Jun 2001 08:44:34 +0200, Andreas Wizemann <AWizemann_at_fvvag.de> wrote:

>Command is as follows:
>
>exp system/manager full=y consistent=y file=mydmpfile log=mylog

Don't use a command, use a CTL file. It's easier to expand and maintain.

You need to get rid of that consistent=y. Unless you're doing export while users are actively *changing* data.

Use buffer=10000000.

Use direct=y (doesn't always work, depending on types of data).

If that still doesn't fix it, consider doing multiple exports of portions of your schema(s). Concurrent execution, to different export files of course.

Cheers
Nuno Souto
nsouto_at_bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Fri Jun 01 2001 - 07:19:21 CDT