|Cause: Through a series of CREATE synonym statements, a synonym was defined that referred to itself.|
|Action: Change one synonym definition so that it applies to a base table or view and retry the operation.|
For example, the following definitions are circular: CREATE SYNONYM s1 for s2;
CREATE SYNONYM s2 for s3
CREATE SYNONYM s3 for s1
CREATE SYNONYM s4 for s4
Check your synonyms with:
select * from all_synonyms where synonym_name = ‘name’ or table_name = ‘name';
I think the best approach here is to focus on the technical details of the mistake first and then follow with any whining, self-justification or philosophy.
Problem in Oracle 10g database on Windows 2000/2003 Professional/Enterprise error message “RemoteOperationException:ERROR:Wrong Password for User“
1. go to Control Panel -> Administrative Tools.
2. Click on Local Security Policy.
3. Local Policies, User Rights Assignment.
4. Double click, ‘Log on as a batch job‘.
5. Add your local user that you are supplying for the Host Credentials.
A massive tsunami triggered by one of the largest earthquakes smashed into Japan, killing hundreds of people. It swept away boats, cars and homes.
My heartfelt condolences to the people who have suffered or lost their near and dear ones in the disaster.
Extend your help to the Tsunami victims here.
Continuing from the previous installment of this series I'll cover in this post some of the inevitable classics regarding Parallel Execution Control. So forgive me if you're bored by the repetition of known facts - however I still see these things too often used incorrectly, therefore I decided: This is worth to mention and remember!
- Up to and including version 10.2 PARALLEL (without any parameters) and NOLOGGING are valid keywords only in DDL commands
There are various “show” commands in SQL*Plus that are convenient short-cuts for simple SQL commands, for example: show parameter show recyclebin show sga show spparameter You may find, though, that the output leaves a little to be desired, for example: show parameter sharing NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ _optimizer_extended_cursor_sharing_r string SIMPLE el cursor_sharing string [...]Mar 11, 2011 10:35am