Home » SQL & PL/SQL » SQL & PL/SQL » not able to execute the explain plan in development in TOAD (Oracle 11g)
not able to execute the explain plan in development in TOAD [message #602104] Fri, 29 November 2013 07:52 Go to next message
na.dharma@gmail.com
Messages: 54
Registered: May 2008
Location: bangalore
Member

Hi

In TOAD when try to click "Explain plan current statement." icon, I getting the below error message.

ORA-00604: error occurred at recursive SQL level 1
ORA-01950: no privileges on table space 'DEFAULT_DATA'

can anybody give some idea to solve this issue?

Thanks
Dharma
Re: not able to execute the explain plan in development in TOAD [message #602109 is a reply to message #602104] Fri, 29 November 2013 09:29 Go to previous messageGo to next message
gazzag
Messages: 267
Registered: November 2010
Location: Bristol, UK
Senior Member
The user you are using to log into TOAD does not have privileges on its default tablespace by the sound of it. Whoever created that user should also have specified something like:

ALTER USER <username> QUOTA <quota> ON default_data;

E.g.

ALTER USER <username> QUOTA 100M ON default_data;


HTH
-g
Re: not able to execute the explain plan in development in TOAD [message #602126 is a reply to message #602109] Fri, 29 November 2013 13:12 Go to previous message
Lalit Kumar B
Messages: 1080
Registered: May 2013
Location: Hi-tech city
Senior Member
I can't help you if it is just a TOAD problem. Its a third party tool.
However, if you want to check the execution plan of a SQL statement, then use SQL*Plus and execute the statement EXPLAIN PLAN FOR <your query>.

If plan table does not exist, then go to performance tuning forum, have a look at the sticky on top. Blackswan has mentioned the steps to do the needful.
Previous Topic: translate
Next Topic: Run same procedure parallely in different sessions with diff parameter value
Goto Forum:
  


Current Time: Wed Apr 16 15:58:27 CDT 2014

Total time taken to generate the page: 0.07667 seconds