OraFAQ Forum: Linux » to run sql script

Home » Infrastructure » Linux » to run sql script (Linux 5.1)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

to run sql script [message #573513]

Sun, 30 December 2012 00:09

irfankundi786@yahoo.com
Messages: 161
Registered: February 2009
Location: pakistan

Senior Member

i want to sent the mail from the database 10g for this i run the script like
@$u01/app/oracle/product/10.2.0/db_1//rdbms/admin/utlmail.sql
but this give error unable to open the script.
how i can fix the error.

Report message to a moderator

Re: to run sql script [message #573516 is a reply to message #573513]

Sun, 30 December 2012 01:48

Michel Cadot
Messages: 54693
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

@$...

I bet something is wrong there, maybe "$" is "/".

Regards
Michel

Report message to a moderator

Re: to run sql script [message #573518 is a reply to message #573516]

Sun, 30 December 2012 02:34

irfankundi786@yahoo.com
Messages: 161
Registered: February 2009
Location: pakistan

Senior Member

@$u01/app/oracle/product/10.2.0/db_1/rdbms/admin/utlmail.sql

i check the path of my oracle home but i am confused about the $ sign is it mandatory????

Report message to a moderator

Re: to run sql script [message #573519 is a reply to message #573518]

Sun, 30 December 2012 02:37

irfankundi786@yahoo.com
Messages: 161
Registered: February 2009
Location: pakistan

Senior Member

i am using linux login as oracle user.
it return error like sp2-0310 unable to open the file.....

Report message to a moderator

Re: to run sql script [message #573521 is a reply to message #573519]

Sun, 30 December 2012 03:06

Michel Cadot
Messages: 54693
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

maybe "$" is "/".

Maybe if you read and check what we post you'll be able to succeed.

Regards
Michel

Report message to a moderator

Previous Topic:	what does exact purpose solved by setting kernel parameters?
Next Topic:	Oracle 11g Idle instance

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 19 04:33:06 CDT 2013

Total time taken to generate the page: 0.10678 seconds