Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Transaction logs full

Transaction logs full

From: Robert Stearns <rstearns1241_at_charter.net>
Date: Mon, 07 Jun 2004 21:59:16 -0400
Message-ID: <10ca7bkhqthk8d1@corp.supernews.com>


Is there a way (SQL syntax or some preparatory command) to cause a statement which implies a possibly large number of operation, either insert or update, to commit every so many rows? In particular the new 'merge ... when not matched insert ...' statement can consume large amounts of log space, depending on the number of 'not matched' rows. Received on Mon Jun 07 2004 - 20:59:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US