Re: Run Oracle without transactions?

Hi.

 Is it possible for you to use an arbitrary commit :

1. Create a table with a single field : CREATE TABLE SEQ_TAB ( TRAN_COUNTER NUMBER(30));
2. For each insert/update/delete line from your input file increase the value of TRAN_COUNTER by 1.
3. Commit every 5000 records ( or whatever you like ).
4. If the update aborts - just restart it and skip the number of records according to TRAN_COUNTER value.

  Good luck. Michael.

  P.S. I would like to know what is your solution,

       because I'm afraid we are going in the same
       direction at my place.

In article <378366F9.4DB6B00A_at_mbox5.singnet.com.sg>,   Anita <anitha_at_mbox5.singnet.com.sg> wrote:
> Hi,
>
> Is there a way to switch off transactions on the Oracle database( run
> the database without transactions)?
> We have a utitlity loading a large amount of data( we do not want to
use
> SQL loader, we should be able to do it with SQL statements) that
cannot
> define a logical commit point, and the data is too huge for any big
roll
> back segment to hold. So we are looking for an option where we can
turn
> off the transactions on the database.
>
> Thanks in advance.
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sun Jul 11 1999 - 14:53:05 CDT