Home » SQL & PL/SQL » Client Tools » Explain Plan in different Tablespace
Explain Plan in different Tablespace [message #270082] Tue, 25 September 2007 11:37 Go to next message
Messages: 7
Registered: August 2007
Junior Member
Hi All,

I am using PL/SQL developer and when I try to execute Explain Plan for a query it asks me to create a plan table. However, I do not have privileges to create a plan table in the user's defualt tablespace, but in a different tablespace. Could you please tell me how to configure PL/SQL developer to create plan table in a different tablespace? Everytime I try to create plan table it tries to do so in the default tablespace and thus throws an error saying that I do not have sufficient privileges.
Any help would be highly appreciated.

Re: Explain Plan in different Tablespace [message #270085 is a reply to message #270082] Tue, 25 September 2007 12:15 Go to previous message
Michel Cadot
Messages: 65155
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just precreate the plan table in your tablespace then it will not ask you to do so.

Previous Topic: Help to stop last field from wrapping in report
Next Topic: Tora on open suse 10.2
Goto Forum:

Current Time: Wed Aug 23 16:36:23 CDT 2017

Total time taken to generate the page: 0.01798 seconds