Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: ** import tuning
A Joshi wrote:
>
> Basically is export taken with direct option any different from regular export?
"Virtual Private Database (VPD) and Oracle Label Security are not enforced during direct path Exports." (from the docs).
Otherwise direct path export is faster than conventional path export, but the import side of things is unaffected by whether or not the export was direct. I use the default RECORDLENGTH for the export, and for the import, I specify COMMIT=Y and an appropriate BUFFER value.
-Mark Bole
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jun 06 2005 - 10:35:43 CDT