| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_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_at_fas.harvard.edu | | Database Applications Specialist FAS Computer Services | +--------------------------------------------------------------------------+
-- Author: Rick Osterberg INET: osterber_at_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_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Fri May 26 2000 - 19:35:08 CDT
(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 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2448.0"> <TITLE>RE: Truncate/load within transaction</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>Truncate is a DDL statement - it means implicit = commit - end of the transaction</FONT> </P> <P><FONT SIZE=3D2>Alex Hillman</FONT> </P> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Rick Osterberg [<A = HREF=3D"mailto:osterber_at_FAS.HARVARD.EDU">mailto:osterber_at_FAS.HARVARD.EDU= </A>]</FONT> <BR><FONT SIZE=3D2>Sent: Friday, May 26, 2000 1:57 PM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: Truncate/load within transaction</FONT> </P> <BR> <P><FONT SIZE=3D2>Question on feasability here. I've got a number = of tables of moderate</FONT> <BR><FONT SIZE=3D2>size (on the order of hundreds of thousands of rows) = which we periodically</FONT> <BR><FONT SIZE=3D2>(mostly daily) pull in from an external data source, = via SQL*Loader. </FONT> <BR><FONT SIZE=3D2>Question is - is it possible to provide transparancy = of that data load,</FONT> <BR><FONT SIZE=3D2>such that the truncate and table load happen within = one transaction? I'd</FONT> <BR><FONT SIZE=3D2>like to set things up such that others looking at = this table see old data,</FONT> <BR><FONT SIZE=3D2>and then see new data as soon as the load = finishes. Right now, with a</FONT> <BR><FONT SIZE=3D2>standard load, they see old data, then an empty = table, then a growing</FONT> <BR><FONT SIZE=3D2>table, and then a full table.</FONT> </P> <P><FONT SIZE=3D2>Thoughts? Many thanks in advance.</FONT> </P> <P><FONT SIZE=3D2>-Rick</FONT> </P> <P><FONT = SIZE=3D2>+--------------------------------------------------------------= ------------+</FONT> <BR><FONT = SIZE=3D2>| &n= bsp; Rick Osterberg = osterber_at_fas.harvard.edu = |</FONT> <BR><FONT SIZE=3D2>| = Database Applications Specialist FAS Computer = Services |</FONT> <BR><FONT = SIZE=3D2>+--------------------------------------------------------------= ------------+</FONT> </P> <BR> <P><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Rick Osterberg</FONT> <BR><FONT SIZE=3D2> INET: osterber_at_fas.harvard.edu</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT> <BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed = from). You may</FONT> <BR><FONT SIZE=3D2>also send the HELP command for other information =
 |
 |