OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » How to copy Sql Script into server

Home » Applications » Oracle Fusion Apps & E-Business Suite » How to copy Sql Script into server

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

How to copy Sql Script into server [message #590798]

Tue, 23 July 2013 01:01

mist598
Messages: 1191
Registered: February 2013
Location: Hyderabad

Senior Member

Hi,

I am having Query select empno,ename,sal from emp and saved it as "emp_sal.sal' in D:/ drive and my question is How to copy sql script to server in Order Managment for example for forms: $cd $ONT_TOP/forms/US like that sql...

Can any one please help me?

Thanks&Regards,
SIva

Report message to a moderator

Re: How to copy Sql Script into server [message #590804 is a reply to message #590798]

Tue, 23 July 2013 01:21

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

Senior Member
Account Moderator

How is this an Oracle question?

Regards
Michel

Report message to a moderator

Re: How to copy Sql Script into server [message #590805 is a reply to message #590804]

Tue, 23 July 2013 01:32

mist598
Messages: 1191
Registered: February 2013
Location: Hyderabad

Senior Member

Thanks for reply,

Yes, it is an Oracle apps..

Regards,
Siva

Report message to a moderator

Re: How to copy Sql Script into server [message #590808 is a reply to message #590798]

Tue, 23 July 2013 02:13

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

mist598 wrote on Tue, 23 July 2013 11:31

Hi,

I am having Query select empno,ename,sal from emp and saved it as "emp_sal.sal' in D:/ drive and my question is How to copy sql script to server in Order Managment for example for forms: $cd $ONT_TOP/forms/US like that sql...

Can any one please help me?

Thanks&Regards,
SIva

Quote:

$cd $ONT_TOP/forms/US

This Location generally contains Forms application (if any)....

Create a scriptfile(<script_name>.sql and copy it to $ONT_TOP/sql directory using Unix command (cp).
Grant 644 permission to it.

I don`t think you have emp table on APPS!

Hope this will help you !

Good lick !

Thanks
Sriram Sanka

Report message to a moderator

Re: How to copy Sql Script into server [message #590809 is a reply to message #590798]

Tue, 23 July 2013 02:39

John Watson
Messages: 8458
Registered: January 2010
Location: Global Village

Senior Member

To copy from Windows to Unix, I usually use pscp.exe which is part of the putty suite,
http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html

Report message to a moderator

Re: How to copy Sql Script into server [message #590811 is a reply to message #590798]

Tue, 23 July 2013 03:03

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

@OP,

If it is only related to copying files(I missed the point here, thanks John) then there are so many tool available.
For Ex: I use winscp to transfer files from windows to Unix.

Sriram

Report message to a moderator

Previous Topic:	Script/API to find approval path...
Next Topic:	No completion options were requested.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 24 00:22:28 CST 2021