script for updating table using file( - Shell Programming and Scripting

unihp1 · #1 (**permalink**) 06-10-2008

Hi,

Data file path (.txt)
Control file(.ctl)

I have delimited file(|).
Sample data:
1|name|50009|DS24|0|12
2|name|30009|DS24|0|13
3|name|20409|DS24|0|14
4|name|20009|DS24|0|15
5|name|10009|DS24|0|16
I want to load this data into a oracle table (update and insert)

Please help me the commands and also syntax.
Unix server name is HU-UX

Thanks in advance.

Thanks and Regards,
Suri_unix

unihp1 · #2 (**permalink**) 06-11-2008

I tried using a temp table then I loaded the data from a file to temp table.
Once temp table having data, used oracle merge loaded the data in the target table. After the data is loaded into a target table, the temp table is dropped.
It is working fine.

But the DBA is not accepting to create temporary table. i am running my code in multiple instance. If I create more number of tables the performance will degrade.

Please help me on this.

Thanks and Regards,
Suri

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
awk updating one file with another, comparing, updating	mecano	Shell Programming and Scripting	11	3 Weeks Ago 03:50 AM
unix script for update or insert records from a file to a oracle table	unihp1	UNIX for Advanced & Expert Users	1	06-11-2008 12:21 AM
Updating table on UNIX server using SFTP	Pallavi_gondkar	UNIX for Dummies Questions & Answers	1	04-04-2008 02:47 AM
updating a column in oracle table using shell script	sveera	Shell Programming and Scripting	3	05-09-2005 10:01 AM
updating a column in a unix table for a particular row	thanuman	Shell Programming and Scripting	4	04-26-2005 04:59 AM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode