Re: Delete operation is very slow

Many reasons why delete * from label might be slow. If you are deleting everything, use the truncate command...It doesn't go through the redo log buffer, but be warned... it is not irreversable.

second question...If you are mirroring the database, use the replication database option. If not, You might want to look into using Snapshots or Views.

Good Luck,
Satar
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
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

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