Re: Oracle question

From: Caryl Lee Fisher <cfisher.dulcian_at_worldnet.att.net>
Date: 1997/11/11
Message-ID: <649kkl$sp1@bgtnsc02.worldnet.att.net>#1/1

You can truncate tables rather than delete records. It is much faster and does not use the rollback segments, but it is unrecoverable!

Paul Dorsey
Dulcian, Inc.

P.S. How do you post so that the posting shows up as a child posting?

Zachary Taylor <taylorzac_at_bah.com> wrote in article <647q4g$6od$1_at_news.bah.com>...
> 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.
>
> Also I need to run this from the command prompt??
>
> Greatly confused any help would be appreciated
>
> Zachary Taylor
> taylorzac_at_bah.com
>
>
>
>
Received on Tue Nov 11 1997 - 00:00:00 CST