Home » SQL & PL/SQL » SQL & PL/SQL » Accessing the plan table (xp, oracle 10g)
Accessing the plan table [message #313493] Sun, 13 April 2008 03:08 Go to next message
swas_fly
Messages: 220
Registered: March 2008
Location: Bhubaneswar
Senior Member
SQL> set autotrace on explain
SP2-0613: Unable to verify PLAN_TABLE format or existence

SQL> desc PLAN_TABLE
ERROR:
ORA-04043: object PLAN_TABLE does not exist


I have installed oracle 9i in my system but i cannout use the plan table,how can i enable it
Re: Accessing the plan table [message #313502 is a reply to message #313493] Sun, 13 April 2008 04:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Ask your DBA to run "utlxplan.sql" script (s)he'll find ORACLE_HOME/rdbms/admin directory.

Regards
Michel
Re: Accessing the plan table [message #313530 is a reply to message #313502] Sun, 13 April 2008 08:31 Go to previous messageGo to next message
swas_fly
Messages: 220
Registered: March 2008
Location: Bhubaneswar
Senior Member
As this is my home computer and oracle is installed in my system,whether i will be able to run this .sql file.
will that solve the problem
If that is the case,whether i have to log in as sysdba or as usual scott
Re: Accessing the plan table [message #313534 is a reply to message #313530] Sun, 13 April 2008 08:40 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
UTLXPLAN.SQL is located in the ORACLE_HOME\RDBMS\ADMIN directory. It contains CREATE TABLE statement, so - yes, you may run it as 'scott'.

However, if you run it as a privileged user, you may use one table for all your users (by creating a public synonym). If you choose to create it for every user, fine - you'll just have more than one PLAN_TABLE tables.
Previous Topic: what's difference between RMAN and Exp/Imp?
Next Topic: how can I get bind values for another session? There are conditions..
Goto Forum:
  


Current Time: Sun Dec 11 02:29:23 CST 2016

Total time taken to generate the page: 0.08884 seconds