Re: Delete operation is very slow

Hi,

this is a typical situation where you should use the TRUNCATE command, NOT the DELETE command, like this:

truncate table label;

TRUNCATE is a DDL command (non-transactional), is very fast, and does not destroy any constraints, etc. (like DROP TABLE does).

Hth,

Pavel
krines_at_my-dejanews.com wrote in message <7118s6$eua$1_at_nnrp1.dejanews.com>...
>Hi,
>
>we have oracle version 7.3 and have a problem with the delete operation.
Every
>time we delete all records from the database, the time for this operation
>increases. The delete operation is very simple:
>
>delete * from label
>commit
>
>First we thought that the rollback segments are the problem but now we have
no
>more ideas.
>
>By the way, is there a easy way, to copy all records from one database to
an
>identical other database with a simple SQL statement? By now we copy every
>table with an "insert into" command from one database to the other.
>
>Thanks for your help...
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Oct 26 1998 - 02:48:36 CST