Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Q: Import and BUFFERS=? and COMMIT=Y
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