Re: table update crashing...

Glen A Stromquist wrote:

> 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?

I'd go home. And make a mental note that you owe it to the c.d.o. group to name names so that we know which vendor it is.

Thanks.

Daniel Morgan Received on Sat Jan 25 2003 - 19:37:50 CST