tag:blogger.com,1999:blog-8873109125023142810.post3786941678147718838..comments2024-03-28T12:50:15.094+05:30Comments on Let's Develop in Oracle: Complex View Merging Transformation and ORA-00979 in Oracle 12cNimish Garghttp://www.blogger.com/profile/15795821721808548808noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-8873109125023142810.post-22993919247799931512018-03-20T14:06:12.758+05:302018-03-20T14:06:12.758+05:30I have installed Oracle database 11g release 2. bu...I have installed Oracle database 11g release 2. but when i try to write in command promote;<br />Enter user name:orcl<br />Enter password: orcl this i gave for my client computer it shows <br />ERROR:<br />ORA-01017:Invalid username/password; logon denied but definetly correct username and password.<br /> pleas help me guys!!Anonymoushttps://www.blogger.com/profile/04773698565458809747noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-34144512291488867742017-06-15T18:45:34.422+05:302017-06-15T18:45:34.422+05:30Wow! An elegant solution once the problem is under...Wow! An elegant solution once the problem is understood.Jeremy Singernoreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-39902759755833709652017-06-15T18:42:27.066+05:302017-06-15T18:42:27.066+05:30No, there was no remote object used.No, there was no remote object used.Nimish Garghttps://www.blogger.com/profile/15795821721808548808noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-53019861976504921262017-06-14T03:42:38.112+05:302017-06-14T03:42:38.112+05:30Is any of the view remote view ?
Query Against Re...Is any of the view remote view ?<br /><br />Query Against Remote View Causes ORA-00979: Not A GROUP BY Expression (Doc ID 1534636.1)Anonymoushttps://www.blogger.com/profile/04805519697488584203noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-82344120159021312692017-06-13T08:48:38.323+05:302017-06-13T08:48:38.323+05:30Yes, I have asked our DBA team to log an SR, I don...Yes, I have asked our DBA team to log an SR, I don't have access to Oracle Support.Nimish Garghttps://www.blogger.com/profile/15795821721808548808noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-23572750840660593472017-06-13T08:06:32.138+05:302017-06-13T08:06:32.138+05:30Please log an SR so the optimizer team can take a ...Please log an SR so the optimizer team can take a look at it. If they dont know about it, they can't solve it :-)Connor McDonaldhttps://www.blogger.com/profile/06246356571229889735noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-23686036377023186862017-06-12T16:57:26.647+05:302017-06-12T16:57:26.647+05:30Thank you for taking the time to post this. We are...Thank you for taking the time to post this. We are moving from 11g to 12c2 this year. We have many queries like this.Keith Russellnoreply@blogger.com