Re: Drop Table Slowness

From: Andre van Winssen $andrew$ <andrew-no-spam-svp_at_info.nl>
Date: Tue, 19 Feb 2002 09:33:43 +0100
Message-ID: <3c720de7$0$225$4d4ebb8e@news.nl.uu.net>

Donna,
how slow is it really?
Did you run a sqltrace on it (look for all recursive sql generated as a result of the drop table command)?
No locks on the table by any chance?
Are there any foreign keys with ON DELETE CASCADE flag referencing your table?

Maybe the global temporary table feature is an option for your application. If you create it with the ON COMMIT DELETE ROWS flag you don't have to delete the rows yourself. Oracle will take care of that. It means you don't have to recreate the table each time.

Regards,
Andre van Winssen

"Donna" <dhoffman0917_at_yahoo.com> wrote in message news:79808a91.0202180533.32b042ca_at_posting.google.com...
> Unfortunately, "TRUNCATE TABLE" is not an option. This application
> has to drop and recreate this table each time it runs.
>
>
> Thanks
> Donna
Received on Tue Feb 19 2002 - 02:33:43 CST