Re: Oracle cursor help

From: steves06@xxxxxxxxxxx (Steve Sapovits)
Date: Mon, 27 Jun 2005 12:30:22 -0400

Reidy, Ron wrote:

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.

--
Steve Sapovits    steves06@xxxxxxxxxxx
.

References:
- RE: Oracle cursor help
  - From: Ron Reidy

Prev by Date: RE: Problems installing Test-Simple.ppd
Next by Date: RE: Oracle cursor help
Previous by thread: RE: Oracle cursor help
Next by thread: RE: Oracle cursor help
Index(es):
- Date
- Thread

Relevant Pages

Re: [PATCH 02/11] vfs: Add better VFS support for page_mkwrite when blocksize < pagesize
... does what it's name claims to - truncate the VM-information about ... way we can migreate one filesystem per patch to the new scheme. ... I would suggest giving the flags to ->setsize their own namespace with ... we want a nicely bisectable migration we'd have to rename the old ...
(Linux-Kernel)
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)