Importing Data Using Unix to Oracle DB

Question

I want to import data on a weekly basis to an Oracle DB. I'm receiving this data on specific location in a server in EDR format. For now I'm uploading them manually using Toad for Oracle uploader wizard. Is there any way to upload them automatically using Unix or any kind of scripting?

here is a sample, note that each field is delimited with pipes bash|112322|ahmed|0|20400101000000||2014|21001111090211|||ahmed|4525435333|jack|0|20400101000000||20191111090211|20111111090211||| — Basheer Raad
– Basheer Raad, Commented Dec 1, 2019 at 13:36
Can you place the sample and the tabel in the question, not comment. You might select a 4 table with 4 columns, easier to understand. — Walter A
– Walter A, Commented Dec 1, 2019 at 14:49

Piyush · Accepted Answer · 2019-11-29 18:36:45Z

3

I would suggest to try out SQL loader through a shell script.

Code:

sqlldr username@server/password control=loader.ctl

two important files:

a. your data file to be uploaded.

b. Control file which states the table to be inserted and the delimiter character and the column fields, etc. basically describe how to load the data.

Oracle Reference

answered Nov 29, 2019 at 18:36

Piyush

8581 gold badge8 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Importing Data Using Unix to Oracle DB

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related