CSV file import to server from local machine

943754

Hi all,

I just want to know whether is there any possibilities to upload a file to database server without server login password?

My requirement is i want to load some data into a table from xyz.csv file using SQL loader. But the problem is xyz.csv file is in my machine i want to transfer it to server, And i know how to copy this file through FTP tools.

FTP tools can be used only when we know the username and password of the (apps or db)user of the server.

If i know only the apps schema name and password is that any possibilities to transfer from my machine to server.

Thanks in advance

Nirmal

Jayaprakash -Oracle

Hi ,

This community is to discuss Oracle Application Server specific issues, you can post this query in Oracle Database community for better response:

Oracle Database

Regards,

Prakash

AmitGargOCE

Agree, You should DB thread for this. Just to quickly answer your question, You can use your desktop client SQL loader (SQL developer graphic tool) to upload you desktop CSV file to database using apps account with doing FTP on DB server.

Thanks

Amit