Re: DIRECT=Y with EXP

"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message news:E2F6A70FE45242488C865C3BC1245DA702712DDA_at_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 believe that the going rate for changing the Y to an N in the script they have been provided with ought to be about £1000, why not offer to do it for half that <VBG>.

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

Thanks to both you and Howard for bringing this up. I'd missed this.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************