Designer 6i - Oracle Reference Error [message #141074] |
Thu, 06 October 2005 18:06 |
lkbhaskar
Messages: 2 Registered: October 2005 Location: CT
|
Junior Member |
|
|
Hi,
I am trying to copy an entity from one container to another.The error message "ORA-20291: integrity constraint(FK_TAB1_TO_TAB2) violated - parent key not found".
Also another message "Relationship ADDFERT/NELOP.sys_c002345 is referencing invalid Entity"
help pls.
|
|
|
Re: Designer 6i - Oracle Reference Error [message #167652 is a reply to message #141074] |
Sat, 15 April 2006 00:52 |
mobinejaz
Messages: 12 Registered: November 2005
|
Junior Member |
|
|
Not only Oracle Designer6i, but entire ORacle product doesn't run smoothly. This is the difference between Mr. Bill Gates and Mr. Larry Elison (Oracle)
I first used Oracle in 1999. Although I liked development in Oracle but I realised that to be a good developer or any other role, you should be all rounder about knowing very well the Oracle file structure, directories, when you run the query, what happens behind the scenes and etc,etc... one must work very hard like Alexender The Great (who conquered the world) if a little wish is there to have command in Oracle/Oracle products.
In fact, I've also left Oracle to have only medium skills in it only because of it's unavailability, the software being expensive, Your fingers get broken by typing questions on forums, brain gets stuck by viewing strange messeges, it's files easily get corrupted and it's jobs are good but are few and great competition is there for interviews & work as compared to friendly Microsoft SQL Server, MySQL, Postgres, Informix,and other technologies. I have observed that in technical forums about 80% of people ask about warning messeges of technology and software application usage problems are the victims of Oracle!
Now, to solve your problem, you can give privileges to your user role by using Server Admin GUI. Definitely, a privilege warning means that you are finguring Oracle without having enough rights granted to you. Every user has a registered repository to work. You either haven't made/designated for you or you are without any privileges to make changes to it.
Install the repository; try this.
Grant select to the repository owner (on SYS.V$PARAMETER) then
Uninstall the existing repository and after that Reinstall the repository.
hope this will solve your problem
bye dear.
|
|
|