Xref: alice comp.databases.oracle.server:56433 Path: alice!news-feed.fnsi.net!hammer.uoregon.edu!arclight.uoregon.edu!newsserver.pacific.net.sg!not-for-mail From: Anita Krishnamurthy Newsgroups: comp.databases.oracle.server Subject: Re: Run Oracle without transactions? Date: Thu, 08 Jul 1999 09:56:19 +0800 Organization: Subscriber of Pacific Internet Lines: 40 Message-ID: <37840543.F914E81F@cls.uob.com.sg> References: <378366F9.4DB6B00A@mbox5.singnet.com.sg> <931358183.12280.0.nnrp-09.9e984b29@news.demon.co.uk> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Mailer: Mozilla 4.5 [en] (WinNT; I) X-Accept-Language: en We are using Oracle 8. Ours' is an object oriented system, and we are trying to load objects into the database. We have another utitlity which does the mapping for us, from objects to relational database(which means we do not have control over which tables a single object maps to, or where the data is stored). This layer uses SQL statements, and we have to go through this layer. And for the same reason that we are loading objects, we cannot define a logical commit point, since we do not know at which point the object references are resolved completely. Jonathan Lewis wrote: > 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@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. > >