Message-Id: <10509.106951@fatcity.com> From: Alex Hillman Date: Fri, 26 May 2000 20:35:08 -0400 Subject: RE: Truncate/load within transaction This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BFC773.690BD730 Content-Type: text/plain; charset="iso-8859-1" Truncate is a DDL statement - it means implicit commit - end of the transaction Alex Hillman -----Original Message----- From: Rick Osterberg [mailto:osterber@FAS.HARVARD.EDU] Sent: Friday, May 26, 2000 1:57 PM To: Multiple recipients of list ORACLE-L Subject: Truncate/load within transaction Question on feasability here. I've got a number of tables of moderate size (on the order of hundreds of thousands of rows) which we periodically (mostly daily) pull in from an external data source, via SQL*Loader. Question is - is it possible to provide transparancy of that data load, such that the truncate and table load happen within one transaction? I'd like to set things up such that others looking at this table see old data, and then see new data as soon as the load finishes. Right now, with a standard load, they see old data, then an empty table, then a growing table, and then a full table. Thoughts? Many thanks in advance. -Rick +--------------------------------------------------------------------------+ | Rick Osterberg osterber@fas.harvard.edu | | Database Applications Specialist FAS Computer Services | +--------------------------------------------------------------------------+ -- Author: Rick Osterberg INET: osterber@fas.harvard.edu Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ------_=_NextPart_001_01BFC773.690BD730 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Truncate/load within transaction

Truncate is a DDL statement - it means implicit = commit - end of the transaction

Alex Hillman

-----Original Message-----
From: Rick Osterberg [mailto:osterber@FAS.HARVARD.EDU= ]
Sent: Friday, May 26, 2000 1:57 PM
To: Multiple recipients of list ORACLE-L
Subject: Truncate/load within transaction


Question on feasability here.  I've got a number = of tables of moderate
size (on the order of hundreds of thousands of rows) = which we periodically
(mostly daily) pull in from an external data source, = via SQL*Loader. 
Question is - is it possible to provide transparancy = of that data load,
such that the truncate and table load happen within = one transaction?  I'd
like to set things up such that others looking at = this table see old data,
and then see new data as soon as the load = finishes.  Right now, with a
standard load, they see old data, then an empty = table, then a growing
table, and then a full table.

Thoughts?  Many thanks in advance.

-Rick

+--------------------------------------------------------------= ------------+
|          &n= bsp;      Rick Osterberg   = osterber@fas.harvard.edu        =         |
|         = Database Applications Specialist     FAS Computer = Services       |
+--------------------------------------------------------------= ------------+


--
Author: Rick Osterberg
  INET: osterber@fas.harvard.edu

Fat City Network Services    -- (858) = 538-5051  FAX: (858) 538-5051
San Diego, = California        -- Public Internet = access / Mailing Lists
---------------------------------------------------------------= -----
To REMOVE yourself from this mailing list, send an = E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of = 'ListGuru') and in
the message BODY, include a line containing: UNSUB = ORACLE-L
(or the name of mailing list you want to be removed = from).  You may
also send the HELP command for other information =