Home » Applications » Oracle Fusion Apps & E-Business Suite » How to copy Sql Script into server
How to copy Sql Script into server [message #590798] Tue, 23 July 2013 01:01 Go to next message
mist598
Messages: 1195
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
Re: How to copy Sql Script into server [message #590804 is a reply to message #590798] Tue, 23 July 2013 01:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How is this an Oracle question?

Regards
Michel
Re: How to copy Sql Script into server [message #590805 is a reply to message #590804] Tue, 23 July 2013 01:32 Go to previous messageGo to next message
mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad
Senior Member
Thanks for reply,

Yes, it is an Oracle apps..

Regards,
Siva
Re: How to copy Sql Script into server [message #590808 is a reply to message #590798] Tue, 23 July 2013 02:13 Go to previous messageGo to next message
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
Re: How to copy Sql Script into server [message #590809 is a reply to message #590798] Tue, 23 July 2013 02:39 Go to previous messageGo to next message
John Watson
Messages: 8922
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
Re: How to copy Sql Script into server [message #590811 is a reply to message #590798] Tue, 23 July 2013 03:03 Go to previous message
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
Previous Topic: Script/API to find approval path...
Next Topic: No completion options were requested.
Goto Forum:
  


Current Time: Thu Mar 28 13:25:07 CDT 2024