Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Transaction without Rollback Segment?
If you are actually doing inserts you'd be better off to use
SQL*Loader with the direct path. Oracle 8 does have the
ability
to limit logging under certain circumstances but that won't
turn off rollback. If your concern is space - commit every
1000 rows or so.
Best of Luck,
Becca
> hi all ,
>
>
> I 'd like to know if can I define a transaction without
using any
> Rollback Segment.
> I want to execute many INSERT INTO... statements without
using any
> Rollback Segment. I think is something like SQL Loader's
direct path.
>
> 10q
>
>
--
This answer is courtesy of QuestionExchange.com
http://www.questionexchange.com/showUsenetGuest.jhtml?ans_id=7482&cus_id=USENET&qtn_id=7990
Received on Mon Nov 08 1999 - 08:39:05 CST