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]