RE: Oracle cursor help

Yes. A TRUNCATE operation is a data dictionary reset of the table's storage to the initial size (the high-water mark). This operation is unrecoverable and does not involve redo, rollback, index operations, trigger firing, etc. All of this is covered to some degree in the concepts manual for your specific version.

-----------------
Ron Reidy
Lead DBA
Array BioPharma, Inc.


-----Original Message-----
From: Steve Sapovits [mailto:steves06@xxxxxxxxxxx]
Sent: Monday, June 27, 2005 10:30 AM
To: Reidy, Ron
Cc: dbi-users@xxxxxxxx
Subject: Re: Oracle cursor help


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

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is intended
to be for the use of the individual or entity named above. If you are not the
intended recipient, please be aware that any disclosure, copying, distribution
or use of the contents of this information is prohibited. Please notify the
sender of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

.

Relevant Pages

  • 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: DBD-Oracle error when inserting a date
    ... To: Reidy, Ron ... I'm binding in the execute statement. ... sender of the delivery error by replying to this message, or notify us by ...
    (perl.dbi.users)
  • RE: Faster Inserting Code
    ... On Wed, 2004-09-22 at 15:35, Reidy, Ron wrote: ... > Well, since you're using Oracle, modify your doand preparestatements as follows: ...
    (perl.dbi.users)
  • Re: Anyone getting blank messages from the list?
    ... Reidy, Ron wrote: ... >For the past couple of days, I have been getting blank messages from Kim ... >Nielsen KN@uniscrap.dk every time I post to dbi-users. ...
    (perl.dbi.users)