| Accessing the plan table [message #313493] |
Sun, 13 April 2008 03:08  |
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 #313530 is a reply to message #313502] |
Sun, 13 April 2008 08:31  |
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 |
 |
Littlefoot
Messages: 21823
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
