Hello All,

I had left an import running overnight. Looks like I made a mistake in setting up next extent too small for the table (16K). Now, the import that normally completes in 4hrs is running for @ 16hrs and isn't even 30% done. The table has grown to @ 350,000 extents.

I stopped the import. And, now want to truncate/drop the table. Its obviously taking its own sweet time. Is there any way to speed the truncate/drop ?

Its a 9204 db on HP.

Thanks