ORA-02292: integrity constraint
Cause: You tried to DELETE a record from a parent table (as referenced by a foreign key), but a record in the child table exists.
Action: The options to resolve this Oracle error are:
This error commonly occurs when you have a parent-child relationship established between two tables through a foreign key. You then have tried to delete a value into the parent table, but the corresponding value exists in the child table.
To correct this problem, you need to update or delete the value into the child table first and then you can delete the corresponding value into the parent table.
Sde.log:
db_sda_execute_stmt::OCIStmtExecute (2292)
All Oracle errors in the blog can be found at: Oracle errors
All ESRI ArcSDE errors in the blog can found at: ArcSDE Errors
Thursday, December 27, 2007
ORA-02292
Posted by Admin at 12/27/2007 02:08:00 PM
Labels: ArcSDE, Oracle, Oracle Error
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment