View Full Version : BUFFER parameter in Oracle EXP utilite
Eugene Pyzhyk
09-16-2004, 01:28 AM
Hello all!
Please, help me in this task:
In Oracle documentation was written about BUFFER in EXP utilite:
"BUFFER
Default: operating system-dependent. See your Oracle operating
system-specific documentation to determine the default value for this
parameter."
Question: how i can detect operation system BUFFER size ? (on W2K for
example)
Thank you!
FredBear
09-16-2004, 08:30 AM
"Eugene Pyzhyk" <pyzhykea@belhard.com> a écrit dans le message de
news:8850346c.0409160128.66c33856@posting.google.com... Hello all! Please, help me in this task: In Oracle documentation was written about BUFFER in EXP utilite: "BUFFER Default: operating system-dependent. See your Oracle operating system-specific documentation to determine the default value for this parameter." Question: how i can detect operation system BUFFER size ? (on W2K for example) Thank you!
Try an export with default size and look at the log file generated, the buffer size taken is there.
--
Regards
Michel Cadot
Eugene Pyzhyk
09-17-2004, 12:21 AM
> > Question: how i can detect operation system BUFFER size ? (on W2K for example) Thank you! Try an export with default size and look at the log file generated, the buffer size taken is there.
Sorry, but i'm not found information about BUFFER in log.
I try to export data by TOAD (Quest software) and by SQLPLUS EXP command...
This is an information in log file:
"Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production
JServer Release 8.1.7.4.1 - Production
Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
About to export specified tables via Conventional Path ...
.. . exporting table XXXXXXXXXX
160 rows exported
.. . exporting table XXXXXXXXXX
260 rows exported
..................
.. . exporting table XXXXXXXXXX
100 rows exported
Export terminated successfully without warnings."
That's all!
MyLounge.com Site Map
Forum:
Cars,
Cell Phone,
Database,
Games,
Home Improvement,
IT,
Music,
School,
Sports,
Web Design,
Web Server,
Weight Loss
The MyLounge.com forum is intended for informational use only and should not
be relied upon and is not a substitute for any advice. The information contained
on MyLounge.com are opinions and suggestions of members and is not a representation
of the opinions of MyLounge.com. MyLounge.com does not warrant or vouch for
the accuracy, completeness or usefulness of any postings or the qualifications
of any person responding. Please consult a expert or seek the services of an
attorney in your area for more accuracy on your specific situation. Please note
that our forums also serve as mirrors to Usenet newsgroups. Many posts you see
on our forums are made by newsgroup users who may not be members of MyLounge.com
Term of Service
vBulletin v3.0.7, Copyright ©2000-2009, Jelsoft Enterprises Ltd.