dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

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) ...


Home > Database Forum > Database and Unix Discussions > Database Discussions > ORA-02291: integrity constraint

Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 09-20-2009, 04:07 AM
Database Newbie
 
Join Date: Aug 2009
Posts: 5
chuikingman is on a distinguished road
Default ORA-02291: integrity constraint

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) 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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads

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.