Truncating tables - slow

[rshivagami]

I am trying to truncate all the tables in my database before doing an import. There are like around 150 tables and I have a procedure to do it which fetches each tablename and then executes a DELETE statement.
But it has been like an hour since I started the process and it still is executing( I think so..) But it never used to take this much time. Can anyone think of a reason for this?

Shiva.

[jdorlon]

Delete Statements are slow because they can be rolled back.

Use TRUNCATE TABLE ...; It is much faster.

To use this command in a stored procedure you will have to use execute immediate, like this :

execute immedate('truncate table mytable');

-John

[cblanco_r]

Try
truncate table ...