remi's adventures in the database realm

./ oracle / scripts

dbverify in nohup

oracle / scripts  October 9th, 2007

Suffering from corruption in your database, it is nearly just as challenging as in real life… read more →


delete large number of records with intermediate commits

oracle / scripts  August 14th, 2007

Have to delete a large number of records and running out of undo tablespace ‘ORA-30036: unable to extend segment by 8 in undo tablespace ‘UNDO’? Script below does a delete with intermediate commits ever ‘x’ records. read more →