Home » Other » 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.

Report message to a moderator

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: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Just precreate the plan table in your tablespace then it will not ask you to do so.

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 03 08:56:02 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.