| what is the use of execution plan [message #148965] |
Tue, 29 November 2005 04:58  |
naveen19
Messages: 24
Registered: November 2005
Location: Chennai
|
Junior Member |
|
|
Hai
what is the use of execution plan, and how to create it and what all the important things should be seen in the ploan.
Regards
Naveen Kumar.K
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: what is the use of execution plan [message #150950 is a reply to message #150544] |
Mon, 12 December 2005 04:20  |
naveen19
Messages: 24
Registered: November 2005
Location: Chennai
|
Junior Member |
|
|
Hai
Mahesh
when i try to change my database name it gives me error
1. i cant able to create my password file
2. plz tell me what is wrong in that query
3. can u tell me how to create password file
SQL> $ORAPWD FILE='F:\oracle\product\10.1.0\Db_1\database\PWDSHANDB.ORA' PASSWORD=SHANDB FORCE=Y;
OPW-00001: Unable to open password-file
SQL>
Thanks in advance,
Naveen
[Updated on: Mon, 12 December 2005 06:37] Report message to a moderator |
|
|
|
| Re: what is the use of execution plan [message #150975 is a reply to message #150950] |
Mon, 12 December 2005 06:41 |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
use orapwd utility from command prompt
or
use the HOST command (if using from sql*plus).
Make sure the path/file exists and in unix these are case sensitive.
and
Normal naming convention is
orapw< sid>
you are using PWD< SID>.ORA
check it out.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
