OraFAQ Forum: Unix » Unix Script to load data into the Oracle server from Oracle client

Home » Infrastructure » Unix » Unix Script to load data into the Oracle server from Oracle client (UNIX)

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

Unix Script to load data into the Oracle server from Oracle client [message #578699]

Mon, 04 March 2013 05:14

ravi23071988
Messages: 5
Registered: March 2013
Location: BBS

Junior Member

Report message to a moderator

Re: Unix Script to load data into the Oracle server from Oracle client [message #578700 is a reply to message #578699]

Mon, 04 March 2013 05:24

Littlefoot
Messages: 17256
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Research use of SQL*Loader. It allows you to load data stored in a file on a client computer into an Oracle database.

Your Unix script would simply call SQLLDR executable.

Report message to a moderator

Re: Unix Script to load data into the Oracle server from Oracle client [message #578703 is a reply to message #578699]

Mon, 04 March 2013 05:25

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

Senior Member
Account Moderator

Report message to a moderator

Re: Unix Script to load data into the Oracle server from Oracle client [message #578704 is a reply to message #578700]

Mon, 04 March 2013 05:30

ravi23071988
Messages: 5
Registered: March 2013
Location: BBS

Junior Member

I my machine SQLLDR is not there.
And the use of sqlldr is prohibited.

I am in great trouble..
Tomorrow i have to submit the procedure or script which loads the data into the Oracle server via Oracle client without using sqlldr command.

Sad

Report message to a moderator

Re: Unix Script to load data into the Oracle server from Oracle client [message #578705 is a reply to message #578704]

Mon, 04 March 2013 05:35

Littlefoot
Messages: 17256
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Do you have access to database server (a computer)? If so, you could utilize external tables feature.

Report message to a moderator

Re: Unix Script to load data into the Oracle server from Oracle client [message #578706 is a reply to message #578705]

Mon, 04 March 2013 05:38

ravi23071988
Messages: 5
Registered: March 2013
Location: BBS

Junior Member

No sever access is restricted.

Only sql connection is provided.
And we have to use only scripts to pass data(.csv file) from my PC to the oracle database via terminal!!

[Updated on: Mon, 04 March 2013 05:40]

Report message to a moderator

Re: Unix Script to load data into the Oracle server from Oracle client [message #578707 is a reply to message #578706]

Mon, 04 March 2013 05:45

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

Senior Member
Account Moderator

Convert your CSV file into INSERT statement using the standard Unix program (grep, sed, awk...). It is not so difficult.

Regards
Michel

Report message to a moderator

Re: Unix Script to load data into the Oracle server from Oracle client [message #578708 is a reply to message #578707]

Mon, 04 March 2013 05:53

ravi23071988
Messages: 5
Registered: March 2013
Location: BBS

Junior Member

Thank you!
I m working on the script...

can you have the standard unix format using grep, sed.
Please....

Report message to a moderator

Re: Unix Script to load data into the Oracle server from Oracle client [message #578710 is a reply to message #578708]

Mon, 04 March 2013 06:00

ravi23071988
Messages: 5
Registered: March 2013
Location: BBS

Junior Member

Like I have

Dept_Id and Dept_Name as the columns in the csv file.

AND
I have created a table Departments in the Oracle Database.

How do i load data?

Report message to a moderator

Re: Unix Script to load data into the Oracle server from Oracle client [message #578721 is a reply to message #578710]

Mon, 04 March 2013 07:27

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

Senior Member
Account Moderator

$ cat dept.txt
10;MyDept

$ sed -e 's/^/insert into dept values (/' -e "s/;/,'/" -e "s/$/');/" dept.txt
insert into dept values (10,'MyDept');

Regards
Michel

Report message to a moderator

Previous Topic:	cron job
Next Topic:	Privilege Delegation problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 19 17:51:41 CDT 2013

Total time taken to generate the page: 0.14185 seconds