Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ** import tuning

Re: ** import tuning

From: Mark Bole <makbo_at_pacbell.net>
Date: Mon, 06 Jun 2005 07:30:42 -0700
Message-ID: <42A45E12.4080100@pacbell.net>


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-l
Received on Mon Jun 06 2005 - 10:35:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US