Re: What's the default buffer size for exp on Solaris?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Tue, 21 Jul 1998 19:24:45 GMT
Message-ID: <35bdea6b.23879737@192.86.155.100>

A copy of this was sent to joelga_at_pebble.org (Joel Garry) (if that email address didn't require changing) On Tue, 21 Jul 1998 17:08:49 GMT, you wrote:

>Thomas Kyte wrote:
>>
>>exp userid=$UID buffer=20000000 file=exp.tmp.dmp full=y >>& expbkup.log
>
>What is the default buffer size for exp on Solaris? 7.3 & 8.05.
>
>jg

Import: Buffer - 30720
Export: Buffer - 4096

These can be found by running EXP or IMP interactively (question and answer mode)... The defaults are printed with the prompts....

$ exp

Export: Release 8.0.3.0.0 - Production on Tue Jul 21 15:21:12 1998 (c) Copyright 1997 Oracle Corporation. All rights reserved.

Username: tkyte
Password:

Connected to: Oracle8 Enterprise Edition Release 8.0.3.0.0 - Production With the Partitioning and Objects options PL/SQL Release 8.0.3.0.0 - Production

Enter array fetch buffer size: 4096 >

[snip]

Export terminated successfully without warnings.

$ imp

Import: Release 8.0.3.0.0 - Production on Tue Jul 21 15:21:36 1998 (c) Copyright 1997 Oracle Corporation. All rights reserved.

Username: tkyte
Password:

Connected to: Oracle8 Enterprise Edition Release 8.0.3.0.0 - Production With the Partitioning and Objects options PL/SQL Release 8.0.3.0.0 - Production

Import file: expdat.dmp >

Enter insert buffer size (minimum is 4096) 30720>

[snip]  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA  

http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Tue Jul 21 1998 - 14:24:45 CDT