Re: Oracle question

From: H. John C. Hopkins <john_spam_free_at_hpe.ufl.edu>
Date: 1997/11/18
Message-ID: <64svdk$fgc@no-names.nerdc.ufl.edu>#1/1

Then use TRUNCATE on the table in question. Truncate deletes ALL rows without generating redo.

The table will need to be in your schema or you'll need the DELETE ANY TABLE system privilege.

I don't know what you mean about "running this from the command prompt", unless you mean your OS command prompt. In that case, no. Do your truncate from SQL*Plus.

Good luck!

-John

Zachary Taylor wrote in message <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 18 1997 - 00:00:00 CST