Re: EXP and DIRECT=Y

From: Murali <oraclems_at_hotmail.com>
Date: 14 Feb 2002 06:27:44 -0800
Message-ID: <22e6597b.0202140627.7959d7dc@posting.google.com>

"Epicentre Team A ANNECY" <djeanneret_at_epicentre.fr> wrote in message news:<a4g6fc$h98$1_at_wanadoo.fr>...
> Hi
> it is recommended to use the "DIRECT=Y" option systematically with EXP or
> IMP?
>
> Thanks
> Denis

Yes, you may speed up export by using DIRECT=Y since you are bypassing the SQL evaluation buffer. There is no reason not to (meaning, I dont know of any) use this parameter. If you have LOB segments then they will be exported by the conventional method(8i +, errors out in 8.0 -), but your other tables will. It has no effect on the import itself, though. Both direct and conventional exports are imported the same way.

Murali
http://www.dbaquest.com/ Received on Thu Feb 14 2002 - 08:27:44 CST