0

I'll be receiving different set of files, say, around 10000 files, in 10 minutes. How can I load the data in the files to the Oracle database using Python?

Improve this question

1 Answer 1

Reset to default
0

you haven't mentioned the file format you need to load, anyway you may try to use sqlldr and load the file in db, use python to convert your file into csv format and invoke the sqlldr, do check this thread https://stackoverflow.com/a/30324469/6039974

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

2 Comments

Thanks for your suggestion. The file format is Json format. I would like to process the data using cx_Oracle. Would like to know more about the mutiprocessing and multithreading in python. How it can be applicable here to process more faster with performance.
performance wise you can stick with sqlldr, anyway if you want to know about multiprocessing this link will give you a head start.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.