How to use bcp utility with oracle dB or any other better options

Question

I have a csv file which has to be bulk imported to oracle dB. I was working on other sybase dB engine before so I had a sample script which has the environment setup for it. Right now I have to do the process in a oracle dB so what should be the first line I know about the rest other parameters but want to know the path which has to be defined when I write path/bcp dbtable in data.txt If anyone could help what should be the path for oracle dB

Answer 1

The primary tools for bulk or flat file loading are:

1. SQL*Loader
2. External Tables (and here)
3. GUI Tools like SQL*Developer

It is much more cumbersome, but if necessary you can roll your own solution with the UTL_FILE PL/SQL package.