Re: Delete operation is very slow

In article <7118s6$eua$1_at_nnrp1.dejanews.com>,   krines_at_my-dejanews.com wrote:
> 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
>

Did you try to use "truncate" command to delete all records from a table? Or simply drop those tables and re-create them if it is appropriate for your case.

Xuening Sun

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Oct 26 1998 - 08:31:30 CST