I've got two tables in one of my databases each currently with 102,650 extents.
At one stage, they had a lot of rows in them, but now they have very few.
I want to reclaim this space drop exporting, dropping, recreating and importing them.
However, it's the truncate and delete that I'm concerned about.
I tried a truncate that ran for 90+ minutes before I killed it. I'm doing deletes on these tables now that have been running almost as long.
Anyone have any idea how long something like this should take?
I've got no messages in my alert log - anyone have any idea how long something like this might take? Am I just not being patient enough?
(HPUX 11i, Oracle 9.2.0.5)
Steve
At one stage, they had a lot of rows in them, but now they have very few.
I want to reclaim this space drop exporting, dropping, recreating and importing them.
However, it's the truncate and delete that I'm concerned about.
I tried a truncate that ran for 90+ minutes before I killed it. I'm doing deletes on these tables now that have been running almost as long.
Anyone have any idea how long something like this should take?
I've got no messages in my alert log - anyone have any idea how long something like this might take? Am I just not being patient enough?
(HPUX 11i, Oracle 9.2.0.5)
Steve