Fi Friends...
I have a table with some 1 million records. Now I'm tring to delete some 300,000 records from that table based on some condition by executing simple SQL query. It couldn't delete for 25 mins...then I killed that session and thought of truncate the table. I opened another session as admin user and try to truncate table but I got following error...
ORA-00054: resource busy and acquire with NOWAIT specified
could anyone tell how to truncate the table...how to free resources??
Thanks in advance
Sandy
"Greatest Rewards come only with Greatest Commitments!"