tag:blogger.com,1999:blog-5309604992043123290.post7734808511343615126..comments2024-03-24T11:22:17.354+01:00Comments on berxblog: Invalid SQL if hint is missing?Martin Bergerhttp://www.blogger.com/profile/16504572924713610305noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-5309604992043123290.post-33540253722825882632010-12-31T14:01:50.798+01:002010-12-31T14:01:50.798+01:00How many rows are returned if you query SYS.TAB_ST...How many rows are returned if you query SYS.TAB_STATS$ ?<br /><br />I was able to execute both the hinted and unhinted versions of the SQL statement on 11.2.0.1 on 64 bit Windows when SYS.TAB_STATS$ contained 0 rows, and also when it contained 798 rows - see my blog article.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5309604992043123290.post-31275369778962066042010-12-30T22:18:47.929+01:002010-12-30T22:18:47.929+01:00Joel,
thank you for your comment.
I did not care a...Joel,<br />thank you for your comment.<br />I did not care about any permission of user PSFT as I run the statement connected as "/ as sysdba"<br />Also no security feature to limit SYS is enabled there. <br />So it's not an issue of grants.Martin Bergerhttps://www.blogger.com/profile/16504572924713610305noreply@blogger.comtag:blogger.com,1999:blog-5309604992043123290.post-3319867365353125292010-12-30T20:31:42.998+01:002010-12-30T20:31:42.998+01:00Does the error go away if you grant select catalog...Does the error go away if you grant select catalog role to PSFT?<br /><br />I'm speculating the no merge keeps the access in the procedure which has sufficient privilege.<br /><br />word: arncembJoel Garryhttps://www.blogger.com/profile/13325061229393838224noreply@blogger.com