Re: How to delete many rows quickly?

From: <david.archer_at_chase.com>
Date: Mon, 30 Aug 1999 15:03:05 GMT
Message-ID: <7qe6f0$pu6$1@nnrp1.deja.com>

If your not concerned with the rollback log ... TRUNCATE TABLE <table name>. Please use this with care. You can not ROLLBACK after a truncate since nothing was logged.

In article <7qdt9n$j7f$1_at_nnrp1.deja.com>, leongjack_at_my-deja.com wrote:
> Hi,
> I use oracle 8.0.5 for solaris to process the logs, there are
> several millions of logs per day, I can load the logs into database
> quickly( with the sql loader ), but when I want to delete the outdate
> logs from the database, I meet trouble. Though I make the rollback
> segment large enough to store the rollback infomation, the speed still
> too slow to bear. How can I remove the rows quickly.
>
> thanx in advance.
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Aug 30 1999 - 10:03:05 CDT