explain plan error ora-01039 East Middlebury Vermont

Address 2648 West St, Middlebury, VT 05753
Phone (802) 462-2975
Website Link http://claritycomputing.com
Hours

explain plan error ora-01039 East Middlebury, Vermont

Comment by Doug Burns -- June 30, 2009 @ 12:53 pm Reply Good one. Did Sputnik 1 have attitude control? The underlying objects (if you do not want to grant SELECT_CATALOG) are V_$SQL_PLAN, V_$SESSION and V_$SQL_PLAN_STATISTICS_ALL (with an underscore). Fill in your details below or click an icon to log in: Email (required) (Address never made public) Name (required) Website You are commenting using your WordPress.com account. (LogOut/Change) You are

I found it. My CEO wants permanent access to every employee's emails. Mark all read Contact Us · · Top Generated in 0.008 seconds in which 0.002 seconds were spent on a total of 3 queries. Cheers, Norm. [TeamT]

I suspect you don't have any privileges to the SYS.PLAN_TABLE as the SYSTEM user. In any case, I have DBA permissions for the server. Create an account to join the discussion. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient.

How do I explain that this is a terrible idea? I just did explan plan for select * from user_users and got the same error. The reason autotrace works, I think, is because the table is owned by SYS plus the package doing the autotrace is also owned by SYS so the autotrace code is able Security Patch SUPEE-8788 - Possible Problems?

Can you give me the link to online help?Thank you. But if I use the autotrace facility in sql prompt as the same user to perform the trace ; I can see the explain plans. start ?/rdbms/admin/utlxplan create public synonym plan_table for sys.plan_table; grant all on plan_table to public; (You can replace public with the names of the schemas you wish to allow explain plan from share|improve this answer answered Feb 19 '14 at 15:00 OldProgrammer 6,18931025 My Issue was in 1 st sql statement Getting explain plan for the view, I have updated the

SQL> grant select on v_exp_test to read_only; Grant succeeded. Instead it shows FULL_PLAN_HASH_VALUE ! 1yearago Visitor Location Email Subscription Enter your email address to subscribe to this blog and receive notifications of new posts by email. Thanks Martin. --- On Sun, 2/1/09, Norman Dunbar <[hidden email]> wrote: From: Norman Dunbar <[hidden email]> Subject: Re: [toad] Insufficient Privs for running Explain Plan To: [hidden email] Date: Sunday, February more hot questions question feed lang-sql about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation

SQL> create view v_exp_test as select * from exp_test; View created. Comment Submit Your Comment By clicking you are agreeing to Experts Exchange's Terms of Use. Regards, 0 Question by:allahabad Facebook Twitter LinkedIn Google LVL 10 Best Solution bypeterside7 I don't think the problem is with the the tables or the view itself, but with the objects Another guess ( which is more probable ) is that, some tables used in the view are granted to some role and you have that role.

How to solve the old 'gun on a spaceship' problem? To start viewing messages, select the forum that you want to visit from the selection below. Replies Follow Rene / 24 Mar 2009 at 6:22pm Hi,Checkout the "Database Privileges" topic in the online help. User1.Table1).

In USER_TAB_PRIVS following privileges exist On 8i: INSERT, UPDATE, DELETE, SELECT On 10g: INSERT, UPDATE, DELETE, SELECT, REFERENCES, ON COMMIT REFRESH, FLASHBACK, DEBUG, QUERY REWRITE Query and sample function code given You can not post a blank message. http://windowslive.com/explore?ocid=TXT_TAGLM_WL_t2_hm_justgotbetter_explore_012009 Sam M. If you access a database link in a session, then the link remains open until you close the session (ORA-02020) root.sh failed after ASM disk creation for 11GR2 Grid Infrastructure Top

Like this:Like Loading... The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that useā€¦ Oracle Database Dealing If not, this is where this error came in.This isthe security control in Oracle to requrie privileges to access the underlying objects of a view when running the Explain Plan. Using the DISPLAY_SQLSET Functionrequires the user to have the SELECT privilege on ALL_SQLSET_STATEMENTS and ALL_SQLSET_PLANS.

What I normally do is this : on the database server itself, login as the SYS user. Sender does not necessarily endorse content contained within this transmission. How to handle a senior developer diva who seems unaware that his skills are obsolete? Comment by coskan -- June 30, 2009 @ 12:45 pm Reply Well it didn't meet the requirement correctly the way this solution did, but I suggested DBMS_XPLAN.DISPLAY_CURSOR if they were able

Free forum by Nabble Edit this page Not the answer you're looking for? If you need more help, please feel free to let me know.Thanks. The reason autotrace works, I think, is because the table is owned by SYS plus the package doing the autotrace is also owned by SYS so the autotrace code is able

What I normally do is this : on the database server itself, login as the SYS user. Create an account to join the discussion. Get 1:1 Help Now Advertise Here Enjoyed your answer? If you want to explain plan your query you'll either require: - select any table privilege, or - explicit select privilege on USER_USERS and all of the underlying objects that the

Is the mass of an individual star almost constant throughout its life? Please turn JavaScript back on and reload this page.Search this communityOracle CommunityBridged communitiesOracle BlogsOracle University TrainingOracle VideosOTN DocumentationOTN Search ResultsSearch forSearch forContentSearch forPeopleSearch forPlacesLast modifiedLast modifiedAll timeLast modified1 dayLast modified7 daysLast