Re: Delete without rollback ? It it possible ?

John Finn wrote in message <35C854F6.9D9ECDEE_at_a.com>...
>Is it possible to delete multiple rows from a table without rollback
>segment overhead, and without possibility for rollback?
>
>Thanks
>
>jfinn
>

I think you want to look up TRUNCATE in the manual. However, this will get rid of all the data as it does not allow a WHERE clause.

• Barry L. Wallis
• Senior Systems Engineer
• SAIC - An Employee Owned Company!
  • application/octet-stream attachment: Barry_L._Wallis.vcf