table update crashing...

I am having a "frustrating" time with a database restructure, and am ready to restore back to its previous state but thought I'd try the group and see if anyone has a suggestion of what to try next.

Here is the scenario, an upgrade to a client app requires a database restructure, which runs thru an executable and accesses a dozen or so sql scripts, but also does some table updates etc. outside of these scripts. The restructure executable craps out while updating quite a large table, watching from dba studio it takes about 25 min to do a full table scan then gets about 14% thru the sort operation. The sql being ran is nothing more that setting a value of 1 to a new column in the large table. Unfortunatly this sql is nowhere to be found in the scripts and must be run somewhere from within the executable, or I'd try and run it manually and comment it out from the script. The vendors support person tells me that the scripts have to be run from within the restruct executable, so that rules out running them one at a time. Unfortunatly they also dont work weekends, so I'm looking at restoring the backup I just took and discussing it more on monday with them :-(

On my end I've created a monster rollback seg and put all others offline, disabled archivelog on the db and turned logging off for the table(s) it seems to be crapping out on. Not sure what else to try next that may coax this thru before I go home tonight.

ideas? Received on Sat Jan 25 2003 - 18:20:36 CST