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:[EMAIL PROTECTED] Sent: Monday, June 27, 2005 10:30 AM To: Reidy, Ron Cc: [email protected] 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 [EMAIL PROTECTED] 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.
