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

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

** import tuning

From: A Joshi <ajoshi977_at_yahoo.com>
Date: Mon, 6 Jun 2005 07:08:30 -0700 (PDT)
Message-ID: <20050606140831.74363.qmail@web60713.mail.yahoo.com>


Hi,
  I have a export taken with direct=y. This is done setting a high recordlengh = 64K. When importing using this export sould I set recordlength or buffer? How high is Ok for buffer? I am on 817 on sun 5.8. I need to do this operation frequently and need to tune it.   Basically is export taken with direct option any different from regular export?   Or is it better to just use regular export (non direct) with high buffer and use the same buffer for import. thanks for your help.                 



Yahoo! Mail Mobile
 Take Yahoo! Mail with you! Check email on your mobile phone.

--

http://www.freelists.org/webpage/oracle-l Received on Mon Jun 06 2005 - 10:13:29 CDT

Original text of this message

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