Re: EXP and DIRECT=Y

Direct=Y is only an option for export. It causes export to skip normal SQL processing, and also causes it to skip the evaluating buffer.

Since the SQL Processing needs to be used if you're going to throw a QUERY= parameter at the database, that's one occasion when you can't DIRECT=Y. Rather more frequently, you'll sometimes want to run export with CONSISTENT=Y, but since that involves rolling row data back to a consistent point in time, and that in turn means that you are performing old-fashioned SQL processing, you'll find DIRECT=Y can't be used when CONSISTENT=Y.

As for the evaluating buffer: it's job is to convert from the database's character set into your (i.e., export's) session's character set. So you can't skip it (DIRECT=Y) if you are not running in exactly the same character set as your database.

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.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

>

>

>

>