I regret for posting a misleading and inappropriate solution. I believe I got this error due to index for component_event_id column and/or CMPNNTVNT_RBI trigger (for adding value to the component_event_id field before insert) on the component_event table were not created properly. I do not know much about Oracle, but one problem which I faced was related to tablespace extent not being available. The auto-extent option was not ‘ON’ and I could not create some components until I changed tablespace settings for auto-extent creation. Not sure, if this has in anyway contributed to the problem.
I have the options of dropping all tables, related indexes and constraints and create them again. So, I proceeded with it. I had manually dropped component_event table, its index and constraints as they are not dropped through “DB Component Configurator” even if we select ALL for component field. The creation of tables for all components was successfully done this time.
I also request the Administrator to delete this thread, as it is misleading.
Thanks DevNull43 and reamon for sharing your views on this.