RE: any way to stop rollback for dml?/8.1.7.1/Solaris 8
Hey Steve, The Rock is coming back to Raw tonight - hope you're ready!! :0) g -Original Message- Sent: Saturday, July 28, 2001 12:30 AM To: Multiple recipients of list ORACLE-L Yes; many thanks! Unfortunately some of this process is updates, but some of it is inserts, so it will still help... Also the link to sqlldr stuff seems helpful as well. There seems to be quite a bit able to be done here; need to get busy with the docs... Thanks also to those who responded with nologging -- but this affects redo, not rollback. I've already set the tables as nologging, but the rollback to undo the transaction is another set of overhead that if I could eliminate would speed things up... But thank you for the helpful spirit in which the message was sent... :) happy weekend... Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: any way to stop rollback for dml?/8.1.7.1/Solaris 8
It's true, it's true!! -Original Message- Sent: Monday, July 30, 2001 9:26 AM To: Multiple recipients of list ORACLE-L Hey Steve, The Rock is coming back to Raw tonight - hope you're ready!! :0) g -Original Message- Sent: Saturday, July 28, 2001 12:30 AM To: Multiple recipients of list ORACLE-L Yes; many thanks! Unfortunately some of this process is updates, but some of it is inserts, so it will still help... Also the link to sqlldr stuff seems helpful as well. There seems to be quite a bit able to be done here; need to get busy with the docs... Thanks also to those who responded with nologging -- but this affects redo, not rollback. I've already set the tables as nologging, but the rollback to undo the transaction is another set of overhead that if I could eliminate would speed things up... But thank you for the helpful spirit in which the message was sent... :) happy weekend... Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: any way to stop rollback for dml?/8.1.7.1/Solaris 8
Steve, Even we do have the same kind of requirement. AFAIK, there is no way except INSERT with APPEND hint (Direct Load Insert). See Direct-load Insert chapter in concepts manual. Unfortunately Direct load insert works with Insert .. select, not Insert .. values syntax. hth, prasad Austin, Steve S To: Multiple recipients of list ORACLE-L steve.s.aust[EMAIL PROTECTED] [EMAIL PROTECTED] cc: Sent by: Subject: any way to stop rollback for root@fatcity.dml?/8.1.7.1/Solaris 8 com 07/27/2001 03:02 PM Please respond to ORACLE-L Does anyone know of a way to inhibit rollback from being generated for DML? We've got a data warehouse load process that we're trying to speed up (involving sqlldr and then some DML afterwards.) The staging tables it uses are entirely for this process -- there's no need to rollback if it fails; we'd truncate them and start again with that set of data. Aside from sqlldr direct mode and import direct mode, can anyone think of ways to do this? Thanks, Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Austin, Steve S INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: any way to stop rollback for dml?/8.1.7.1/Solaris 8
nologging isnt any good except for a few things, and normal DML is not it. all normal DML is logged regardless of nologging/unrecoverable options. joe [EMAIL PROTECTED] 07/27/01 04:11PM alter table schema.table_name nologging; Jenny Jacobson www.oracle-dba-consulting.com On Fri, 27 Jul 2001, Austin, Steve S wrote: Does anyone know of a way to inhibit rollback from being generated for DML? We've got a data warehouse load process that we're trying to speed up (involving sqlldr and then some DML afterwards.) The staging tables it uses are entirely for this process -- there's no need to rollback if it fails; we'd truncate them and start again with that set of data. Aside from sqlldr direct mode and import direct mode, can anyone think of ways to do this? Thanks, Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Austin, Steve S INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenny Jacobson INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: JOE TESTA INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: any way to stop rollback for dml?/8.1.7.1/Solaris 8
Steve, As far as speeding up the sqlldr process, you could take a look at an article on O'Reilly's web site. It's at http://oracle.oreilly.com/news/oraclesqlload_0401.htmland documents the fairly painless process I used to speed up data loads we are doing here. HTH Stephen Andert [EMAIL PROTECTED] 07/27/01 12:02PM Does anyone know of a way to inhibit rollback from being generated for DML?We've got a data warehouse load process that we're trying to speed up(involving sqlldr and then some DML afterwards.) The staging tables it usesare entirely for this process -- there's no need to rollback if it fails;we'd truncate them and start again with that set of data.Aside from sqlldr direct mode and import direct mode, can anyone think ofways to do this? Thanks,Steve-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Austin, Steve S INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: any way to stop rollback for dml?/8.1.7.1/Solaris 8
alter table schema.table_name nologging; Jenny Jacobson www.oracle-dba-consulting.com On Fri, 27 Jul 2001, Austin, Steve S wrote: Does anyone know of a way to inhibit rollback from being generated for DML? We've got a data warehouse load process that we're trying to speed up (involving sqlldr and then some DML afterwards.) The staging tables it uses are entirely for this process -- there's no need to rollback if it fails; we'd truncate them and start again with that set of data. Aside from sqlldr direct mode and import direct mode, can anyone think of ways to do this? Thanks, Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Austin, Steve S INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenny Jacobson INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: any way to stop rollback for dml?/8.1.7.1/Solaris 8
Yes; many thanks! Unfortunately some of this process is updates, but some of it is inserts, so it will still help... Also the link to sqlldr stuff seems helpful as well. There seems to be quite a bit able to be done here; need to get busy with the docs... Thanks also to those who responded with nologging -- but this affects redo, not rollback. I've already set the tables as nologging, but the rollback to undo the transaction is another set of overhead that if I could eliminate would speed things up... But thank you for the helpful spirit in which the message was sent... :) happy weekend... Steve -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 3:11 PM To: Multiple recipients of list ORACLE-L Steve, Even we do have the same kind of requirement. AFAIK, there is no way except INSERT with APPEND hint (Direct Load Insert). See Direct-load Insert chapter in concepts manual. Unfortunately Direct load insert works with Insert .. select, not Insert .. values syntax. hth, prasad Austin, Steve S To: Multiple recipients of list ORACLE-L steve.s.aust[EMAIL PROTECTED] [EMAIL PROTECTED] cc: Sent by: Subject: any way to stop rollback for root@fatcity.dml?/8.1.7.1/Solaris 8 com 07/27/2001 03:02 PM Please respond to ORACLE-L Does anyone know of a way to inhibit rollback from being generated for DML? We've got a data warehouse load process that we're trying to speed up (involving sqlldr and then some DML afterwards.) The staging tables it uses are entirely for this process -- there's no need to rollback if it fails; we'd truncate them and start again with that set of data. Aside from sqlldr direct mode and import direct mode, can anyone think of ways to do this? Thanks, Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Austin, Steve S INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Austin, Steve S INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).