Re: Drawbacks for direct path

From: Goran <goran99_remove_at_yahoo.com>
Date: Mon, 13 Dec 2004 22:52:54 +0100
Message-ID: <cpl2vt$qe0$1@fegnews.vip.hr>

"zeb" <spam_at_nowhere.com> wrote in message news:41bdfca9$0$11630$636a15ce_at_news.free.fr...
> Hi,
>
> It seems direct path for export and SQL Loader is always
> quicker than conventional path ...
>
> What are the drawbacks for direct path ?
> Why not to use always direct path ?
> When it is better to use diret path and
> when it is better to use conventional path ?
>
> Thanks for your lights ...
>
> Oracle 8i, 9i
> HP-UX 11.0 AIX 5L
>

Direct path export (8i, not sure about other versions, not sure if it's platform specific or generic) behaves very wrong if a table has chained/migrated rows. So wrong that it produces unusable dump. Easy to reproduce...

Regards... Received on Mon Dec 13 2004 - 15:52:54 CST