Re: 9.2.0.4: Build single task EXP

· sybrandb_at_hccnet.nl <sybrandb_at_hccnet.nl>:

> 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?

No, it's not. Other people seem to be able to build expst in Oracle 9.2.0. I'm not. So I wonder if I'm doing something wrong. Or rather: I wonder what am I doing wrong.

> First of all, only 9.2.0.8 is potentially supported, all other
> versions are in sustained support.

Understood. Is that important for the question that I asked?

> 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.

Understood. But I didn't ask Oracle, did I? :) At least I did not ask them on an "official channel", so to speak.

Any, that doesn't answer the question, does it? :) Would it be possible to build expst on 9.2.0.8? Should it possible to build it on 9.2.0.4?

> 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

I'm running EXP on the database server. I suppose EXP of 9.2.0 is clever enough to use the fastest communication mechanism.

> - use Direct=Y

I'm doing that.

> - if you don't use direct, crank up the buffer parameter on the exp
> commandline

I use BUFFER=20m and recordlength=64k.

> 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.

It allows to recover data, which is stored in the export. That's sufficient.

Michael Received on Fri Aug 29 2008 - 12:12:59 CDT