DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: need help!!

  1. #1
    Join Date
    Oct 2000
    Posts
    144
    I'm unable to rebuild index on a particular table because I receive an error:

    ORA-00054:resource busy and acquire with NOWAIT specified

    My question is how can I find out who is using this table so I can kill the session?

  2. #2
    Join Date
    Sep 2000
    Posts
    384
    see the v$access table
    Radhakrishnan.M

  3. #3
    Join Date
    Sep 2000
    Posts
    384
    There is no need to kill a session for rebuilding the index ..

    Use the cool new feature

    alter index indexname rebuild online ;
    Radhakrishnan.M

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width