Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    1

    Unanswered: sqlplus locks when i am trying to delete a record

    Something really strange is happening (Oracle 8i). I have a database and when i try to delete a record which doesn´t exist the sqlplus becomes locked. And other tables the sqlplus returns the correct message "0 rows deleted".
    i.e: table home
    --------------------------------
    | id(Integer) | address(String) |
    --------------------------------
    | 1 | addr1 |
    | 2 | addr2 |
    | 3 | addr3 |
    --------------------------------

    When i try: "delete from home where id = 5" the SQLPlus locks!!! What is going on? Could it be the relashionship between tables?

    tks,

    Carlos.

  2. #2
    Join Date
    Jan 2003
    Location
    Woking
    Posts
    107

    Re: sqlplus locks when i am trying to delete a record

    Originally posted by carlosk
    Something really strange is happening (Oracle 8i). I have a database and when i try to delete a record which doesn´t exist the sqlplus becomes locked. And other tables the sqlplus returns the correct message "0 rows deleted".
    i.e: table home
    --------------------------------
    | id(Integer) | address(String) |
    --------------------------------
    | 1 | addr1 |
    | 2 | addr2 |
    | 3 | addr3 |
    --------------------------------

    When i try: "delete from home where id = 5" the SQLPlus locks!!! What is going on? Could it be the relashionship between tables?

    tks,

    Carlos.
    Hi,

    I think that the table you are trying to delete is locked.
    Check if the object is locked using the following SQL

    SELECT b.object_name
    FROM v$locked_object a,
    all_objects b
    WHERE a.object_id = b.object_id


    Hope it Helps
    nn

Posting Permissions

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