ORA-01502 when inserting record..
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ORA-01502 when inserting record..

Hybrid View

  1. #1
    Join Date
    Feb 2001
    Posts
    39

    Angry ORA-01502 when inserting record..

    Hi All,
    I am having the above error code when inserting records into a table. The exact error code is:

    ORA-01502: index'XXXX.pk' or partition of such index is nin unusable state
    ORA-02063: preceding line from ****
    ORA-06512: at *******', line 5
    ORA-04088: error during execution of trigger '*****'

    I found a few things unusual about the table. It seems as if there are duplicate values in the primary key column and I am thinking that has something to do with the problem. I have rebuilt the index and the problem is still occuring. Thanks for you help.

    Dee.

    My system is as follows:
    Oracle 8.1.6
    Windows NT server
    God Bless

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    did you disable the primary key and then re-enable it after entering duplicate values, I would delete the duplicate values if I was you

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095

    Re: ORA-01502 when inserting record..

    Originally posted by smallpin
    Hi All,
    I am having the above error code when inserting records into a table. The exact error code is:

    ORA-01502: index'XXXX.pk' or partition of such index is nin unusable state
    ORA-02063: preceding line from ****
    ORA-06512: at *******', line 5
    ORA-04088: error during execution of trigger '*****'

    I found a few things unusual about the table. It seems as if there are duplicate values in the primary key column and I am thinking that has something to do with the problem. I have rebuilt the index and the problem is still occuring. Thanks for you help.

    Dee.

    My system is as follows:
    Oracle 8.1.6
    Windows NT server
    your xxxxx.pk index is in unusable state. Check dba_indexes for unusable partitions
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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