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
rubhatta
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.

Thanks.
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: 64111
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.

Regards
Michel
Previous Topic: Help to stop last field from wrapping in report
Next Topic: Can't INSERT INTO table
Goto Forum:
  


Current Time: Mon Dec 05 15:09:41 CST 2016

Total time taken to generate the page: 0.09042 seconds