Re: DIRECT=Y with EXP

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Wed, 31 Jul 2002 20:29:32 +0100
Message-ID: <3d483a9d$0$8509$cc9e4d1f@news.dial.pipex.com>

"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message news:E2F6A70FE45242488C865C3BC1245DA702713BF9_at_lnewton.leeds.lfs.co.uk...
> Niall,
>
> it isn't as simple as that I'm afraid - and I also wouldn't go anywhere
> near this 'dba' person anyway.
> He refuses to change the setting.
> He refuses to beleieve me when advised about 'free space fragmentation'
> caused by the compress parameter.
> He refuses to change it so that I can import his bloody exports anyway.
> I spend far too many hours getting his stuff into our test system - and
> he complains about how long it takes.
> He (used to) export every night, drop and reimport - to get data into a
> single efficient (!) extent.
> He has done performance tests and proved that Oracle are wrong when they
> say that one extent is no better on performance.
> etc etc.

Ah in that case I would recommend that he uses many small files for his tablespaces spread over many disks. There are as you know many reasons for this. I'm sure you could make a convincing argument. Or am i just a troublemaker.

>
> Having dealt with him on many occasions, there is only one word for him
> - 'Merchant Banker' :o)

yes well. Received on Wed Jul 31 2002 - 14:29:32 CDT