Re: Run Oracle without transactions?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 7 Jul 1999 15:31:54 +0100
Message-ID: <931358183.12280.0.nnrp-09.9e984b29@news.demon.co.uk>

What is the version of Oracle ?

Can you expand on why you cannot define a logical commit point, and why SQL*Load is not a valid option ?

How much control do you have over the code in the loading utility ?

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Anita wrote in message <378366F9.4DB6B00A_at_mbox5.singnet.com.sg>...
>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.
>
Received on Wed Jul 07 1999 - 09:31:54 CDT