Home » RDBMS Server » Performance Tuning » Unable to generate explain plan in production database
Unable to generate explain plan in production database [message #233921] Sat, 28 April 2007 04:35 Go to next message
kesevan
Messages: 17
Registered: April 2007
Location: MUMABI
Junior Member

in my production database, 
when i try to generate the explain plan .... i found the following error: 


SQL> set autotrace traceonly
SP2-0613: Unable to verify PLAN_TABLE format or existence
SP2-0611: Error enabling EXPLAIN report
SQL> @c:\oracle\ora92\rdbms\admin\utlxplan.sql
create table PLAN_TABLE (
*
ERROR at line 1:
ORA-01950: no privileges on tablespace 'TOOLS'


Kindly note, my production database is in Amsterdam and i don't have any privilege on this 
database. My production database user id : DBSNMP..Iam in a position to tune my bad SQL under this user : DBSNMP in production database. 

please guide me what is the problem, so that i can communicat with my production team 
to rectify the above error.
[CODE][/CODE]
Re: Unable to generate explain plan in production database [message #233928 is a reply to message #233921] Sat, 28 April 2007 05:06 Go to previous message
Brayan
Messages: 315
Registered: June 2002
Senior Member
Hi,

Quote:

ORA-01950: no privileges on tablespace 'TOOLS'



You are trying to create table in TOOLS tablespace for which you do not have rights!

Brayan.
Previous Topic: oracle 10g slows down pc terribly
Next Topic: How to generate statspack report for a patricular user in my TEST database ?
Goto Forum:
  


Current Time: Mon Nov 04 15:22:48 CST 2024