Re: Delete operation is very slow

From: Douglas Dunyan <dm^noise_for_spammers^dunyan_at_hotmail.com>
Date: Mon, 26 Oct 1998 09:15:57 GMT
Message-ID: <36343D4C.8287DCA2@hotmail.com>

Does
truncate label;
go any faster?

Doug

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
Received on Mon Oct 26 1998 - 03:15:57 CST