ORA-02291: integrity constraint - Database Discussions
This is a discussion on ORA-02291: integrity constraint - Database Discussions ; Hi, When I run the insert command . INSERT INTO BS_COMPONENT_PARAMETER (N_COMP_ID, C_PARAM_GROUP, C_PARAM_NAME, C_PARAM_VALUE) VALUES ('7','CHANNEL','RETRY_NUMBER','0'); I get below error after commit ; SQL> commit; commit * ERROR at line 1: ORA-02091: transaction rolled back ORA-02291: integrity constraint (FRWKADMIN.FK_COMPONENT_PARAMETER) ...
![]() |
| | LinkBack | Thread Tools | Display Modes |
|
#1
| |||
| |||
| When I run the insert command . INSERT INTO BS_COMPONENT_PARAMETER (N_COMP_ID, C_PARAM_GROUP, C_PARAM_NAME, C_PARAM_VALUE) VALUES ('7','CHANNEL','RETRY_NUMBER','0'); I get below error after commit ; SQL> commit; commit * ERROR at line 1: ORA-02091: transaction rolled back ORA-02291: integrity constraint (FRWKADMIN.FK_COMPONENT_PARAMETER) violated - parent key not found What is wrong in my command and table and index ?? How I can find out which index is the table link ??? How to fix the error ?? I do not know much about table structure .Please advice . SQL> select * from tab; TNAME TABTYPE CLUSTERID ------------------------------ ------- ---------- BS_ACCOUNT TABLE BS_ACCOUNT_PROFILE TABLE BS_AUDIT_TRAIL TABLE BS_AUDIT_TRAIL_ACTION TABLE BS_AUDIT_TRAIL_FUNCTION TABLE BS_AUDIT_TRAIL_OBJ_TYPE TABLE BS_AUDIT_TRAIL_VIEW VIEW BS_COMPONENT TABLE BS_COMPONENT_PARAMETER TABLE BS_ERROR_CODE_VIEW VIEW BS_INVOCATION TABLE TNAME TABTYPE CLUSTERID ------------------------------ ------- ---------- BS_PRODUCT_CONFIG_DATA TABLE BS_PRODUCT_DOMAIN TABLE BS_PRODUCT_ERROR TABLE BS_PRODUCT_TYPE TABLE BS_PROFILE_DATA TABLE BS_PROFILE_RIGHT TABLE BS_SYSTEM_CONFIG_DATA TABLE CI_DELIVERY TABLE CI_MESSAGE TABLE FRWK_VERSION_LEVEL TABLE INSTALL_PRD_PARAM TABLE 22 rows selected. |
![]() |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| join tables, having, not exists (case end) ...? | Database Administrator | sqlserver-programming | 7 | 04-22-2008 02:05 PM |
| A question about my DW model | saxontse | olap | 0 | 04-04-2008 01:32 AM |
| New JDBC 1.2 driver runs slower than JDBC 1.1 driver-- expected?? | Database Administrator | ms-sqlserver | 6 | 03-25-2008 04:34 PM |
| PCI Timing Contraints ignored | Database Administrator | Arch | 2 | 03-06-2008 11:26 AM |
| Redo Log File Sizes | Database Administrator | Oracle Server | 4 | 01-25-2008 10:32 PM |
All times are GMT -4. The time now is 10:20 PM.




Linear Mode
