Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Location
    IL
    Posts
    73

    Unanswered: Is there a way to state 'wait' in a ddl statement

    Hi,

    I'm getting an error that the resource was busy when trying to drop a table. Is there a way to state 'wait' till the resource is not used in a ddl command as in the 'select .. for update nowait; statement' ?

    Tal Olier (otal@mercury.co.il)

  2. #2
    Join Date
    Dec 2002
    Location
    Netherlands
    Posts
    118
    No, you'll have to end all transactions accessing the object.

    Good luck!
    Remi Visser

    Oracle Database Administrator
    (OCP certified 8i)

    Homepage: http://home.remidian.com/

Posting Permissions

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