Re: Delete operation is very slow

The time required by the statement may be related to foreign key constraints being verified as you delete. Truncate is still the best way, but if there are foreign key cosntraints enabled, you'll get an error message.
Disable the constraints first, then truncate.

Sylvain Leclerc, DBA
INT Systèmes d'information
Membre du Groupe Magrit
sleclerc_at_magrit.com

> -----Original Message-----
> From: Douglas Dunyan [SMTP:dm^noise_for_spammers^dunyan_at_hotmail.com]
> Posted At: Monday, October 26, 1998 4:16 AM
> Posted To: server
> Conversation: Delete operation is very slow
> Subject: Re: Delete operation is very slow
>
> 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 - 07:33:51 CST