DIRECT=Y with EXP

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Wed, 31 Jul 2002 09:38:51 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA702712DDA@lnewton.leeds.lfs.co.uk>

Denis,

probably for the same reason that COMPRESS=Y is still the default even after 10+ years of Oracle trying to convince people that putting all your data in one extent has no effect on performance. Mind you I have a customer who has a DBA who believes otherwise :o(

And, get this, when asked to refrain from sending export files created with compres=yes they say, and I quote the dba, "we have to use compress=y because of the way that Oracle was installed" - I refuse to ask then what they mean :o)

I have had problems with DIRECT=Y in the past. I can't rememeber exactly what they were, but something to do with incompatiblem character sets on the server and client I think.

Cheers,
Norman.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: Epicentre team A [mailto:oracle_at_epicentre.fr] Posted At: Wednesday, July 31, 2002 8:51 AM Posted To: server
Conversation: DIRECT=Y with EXP
Subject: DIRECT=Y with EXP

Why this option is never the default option ? What are possible problems to export always with DIRECT=Y for bypass sql
processing on SGA

system configuration: Oracle 8.1.7, NT 2000 Server.

Thanks
Denis Jeanneret Received on Wed Jul 31 2002 - 03:38:51 CDT