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

    Red face Unanswered: error with delete table

    hi,
    i have oracle 8i on HP UNIX 11, when i use this sql command for to delete table: delete from table, i receive this oracle error:

    ora-02292:integrity constraint (schema.contrainte) violeted
    how can i resolve this problem.
    please, help me.
    thanks

  2. #2
    Join Date
    Apr 2003
    Location
    NY
    Posts
    208

    Re: error with delete table

    Sounds like you are deleting data that is still reference by a foreign key to another table. You will need to either update the foreign key, or delete the record from the parent table that the key is referencing.

    Originally posted by dngaya
    hi,
    i have oracle 8i on HP UNIX 11, when i use this sql command for to delete table: delete from table, i receive this oracle error:

    ora-02292:integrity constraint (schema.contrainte) violeted
    how can i resolve this problem.
    please, help me.
    thanks

Posting Permissions

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