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

Home -> Community -> Usenet -> c.d.o.misc -> Q: Import and BUFFERS=? and COMMIT=Y

Q: Import and BUFFERS=? and COMMIT=Y

From: Gary Assa <gsa_at_panix.com>
Date: 1997/07/08
Message-ID: <5ptk69$cjh@panix.com>#1/1

What exactly does this do???? I mean, what should I set the BUFFER equal to?  

When I call Oracle, they just tell me word for word what is on the book. No help at all.  

I set BUFFER=4096 and even tried 1048576 and I see no difference? It still seems to commit after every row?  

What effect would a LONG RAW from an import file have??  

My goal is that I want to commit after 16 or 32 or 64 rows (just like SQL*Load, so as not to blow up rollback segs). Received on Tue Jul 08 1997 - 00:00:00 CDT

Original text of this message

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