Re: 9.2.0.4: Build single task EXP

From: <sybrandb_at_hccnet.nl>
Date: Fri, 29 Aug 2008 15:29:53 +0200
Message-ID: <v5ufb419puuohclpdgmhvavcj64ijpig3n@4ax.com>


On Fri, 29 Aug 2008 15:01:59 +0200, Michael Schmarck <usenet-michael_at_schmarck.cn> wrote:

>Is it at all possible to build expst on 9.2.0.4?

The question is irrelevant.
First of all, only 9.2.0.8 is potentially supported, all other versions are in sustained support.
Oracle has stated specifically it doesn't support single task linking, so whatever 'tric' you are going to apply, they are not going to support it.

Apart from that:
There are conventional methods to speed up export. To mention a few
- Make sure you don't use TCP/IP as a communication mechanism, but use BEQ and/or IPC instead
- use Direct=Y
- if you don't use direct, crank up the buffer parameter on the exp commandline
- use a sensible recordlength.

If you desire to speed up exp because you use it as a backup, you need to be warned: export does not constitute a backup.

-- 
 
Sybrand Bakker
Senior Oracle DBA
Received on Fri Aug 29 2008 - 08:29:53 CDT

Original text of this message