Delete operation is very slow

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 - 01:37:42 CST