Home » Other » Training & Certification » what is the use of execution plan
what is the use of execution plan [message #148965] Tue, 29 November 2005 04:58 Go to next message
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 #148978 is a reply to message #148965] Tue, 29 November 2005 06:15 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10692
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/toc.htm
Re: what is the use of execution plan [message #148979 is a reply to message #148978] Tue, 29 November 2005 06:35 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10692
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Just curious.
Saw your posting.

http://www.orafaq.com/forum/t/55713/42800/

You are 9i certified and asking what execution plan is?
Or I misunderstood (as usual!!??)
Re: what is the use of execution plan [message #150507 is a reply to message #148979] Thu, 08 December 2005 04:05 Go to previous messageGo to next message
naveen19
Messages: 24
Registered: November 2005
Location: Chennai
Junior Member

Hi
Mahesh Rajendran,

I have Database name 'UDIDB'can i able to change the database name to 'REACHDB' if so possible plz tell me

Thanks in advance,
Naveen
















































Re: what is the use of execution plan [message #150544 is a reply to message #150507] Thu, 08 December 2005 06:20 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10692
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://www.oracle.com/technology/oramag/code/tips2002/102702.html
Re: what is the use of execution plan [message #150723 is a reply to message #150544] Fri, 09 December 2005 06:02 Go to previous messageGo to next message
naveen19
Messages: 24
Registered: November 2005
Location: Chennai
Junior Member

Hi mahesh
Thanks for ur reply,


Regards
Naveen
Re: what is the use of execution plan [message #150950 is a reply to message #150544] Mon, 12 December 2005 04:20 Go to previous messageGo to next message
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 Go to previous message
Mahesh Rajendran
Messages: 10692
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.
Previous Topic: build internt application volume 1 & 2
Next Topic: OCA OCP(application development) certification
Goto Forum:
  


Current Time: Sun May 31 03:21:54 CDT 2020