Re: Run Oracle without transactions?

SQL*Loader has a 'direct load' option,
and there is now (8.1 only I think) an
API so that 3GL programs can call
the direct load subroutines.

However, this is NOT the same as
switching off transactions' - it is
bypassing all the normal database
activity, pre-creating things that look like Oracle blocks in local memory,
than slamming them into the database
files.

It looks as if you would need to rewrite your entire utility set in order to take advantage of this API - and even then
there are features of it that may make
it inappropriate to your requirement.

--

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

Anita Krishnamurthy wrote in message <378475E2.734866B9_at_cls.uob.com.sg>...
>So do I conclude that there is no way I can turn transactions off on the
>database? I was told that this is how Oracle runs when loading is done
using SQL
>Loader. I was wondering if there is a way for us to do it. This would be a
>solution for us.
>
Received on Thu Jul 08 1999 - 05:30:55 CDT