Why don't you speak with the DBAs at your site? They can tell you
> what they want, and if it goes south, they will have themselves
> to blame.
We have some ongoing dialogue. Mostly they want me to stop
hammering their database. ;-)
What seemed to work well was this: select the rows I want to
keep into a new table; truncate the old table; drop the old
table; rename the new table to the old; redo indices, etc. The
part that surprised me was the truncate. Simply dropping a
table without first truncating it seemed to take a lot longer.
RE: Oracle cursor help ... want to keep into a new table; truncate the old table; ... drop the old table; rename the new table to the old; ... > To: Reidy, Ron... (perl.dbi.users)
Re: Backups and shadowed system disk ... >> Paging does not involve any of those operations. ... The SWAPPER does not create, delete, extend, truncate or rename any files. ... (comp.os.vms)
