Re: Oracle question

From: Gerard M. Averill <gaverill_at_chsra.wisc.edu>
Date: 1997/11/10
Message-ID: <6481bn$1dlc$1_at_news.doit.wisc.edu>#1/1

In article <647q4g$6od$1_at_news.bah.com>, "Zachary Taylor" <taylorzac_at_bah.com> wrote:
>I have a large database about 120,000 records and I want to delete the
>entire thing. I do not want any information saved in case of anything. I
>just want to purge it. I am getting rollback segment errors. And I was
>told to increase these. But I do not think I should even be using these
>because I do not care about the data. There is nothing I would evere want
>to rollback on.
>

TRUNCATE TABLE <table-name> should do the trick.

Cheers,
G.

---

Gerard M. Averill, Associate Researcher
CHSRA, University of Wisconsin - Madison GAverill_at_chsra.wisc.edu Received on Mon Nov 10 1997 - 00:00:00 CET