Our application runs on Solaris 8 and uses DB as oracle 8. I want to truncate one of the table which includes more than 200k row but truncate could not succeed.
After 6 hours waiting, I saw an error related with Shared memory. But when I exit command with CTRL+C, I saw that most of the rows were deleted. Unless none of the extents were returned.
Right now, extent count is 99561. How can I return back those extents? Application is running and use that table. I can not stop it. Is there way to succeed?
I'll appreciate for your help