0

I have a control file to load data from flat file to Table. what's next? How do I run this file to load data? I have Oracle SQL Developer and SQL*PLUS

PythonDeveloper
  • 289
  • 1
  • 4
  • 24

1 Answers1

1

You need to use sqlldr command to execute sql loader to load data.

sqlldr username@server/password control=loader.ctl

For more details, see this.

Cheers!!

Popeye
  • 35,427
  • 4
  • 10
  • 31
  • Just to add - it is to be run at the operating system command prompt. SQL*Loader installs along with the database; if you (the OP) didn't install it, then there's a possibility that you don't have it on your computer. In that case, download & install Oracle Client. Loader is placed under the *utilities*. – Littlefoot Oct 08 '19 at 18:26
  • I have installed oracle client locally. I do not see *utilities under Oracle-OraClientHome folder in startup menu – PythonDeveloper Oct 08 '19 at 19:17
  • @Ummed we're not talking about GUIs...you'll need to open a cmd window and manually CD to your $ORACLE_HOME/bin directory and see if there is a sqlldr program there. If it's there, you're good. If not, you'll need to download a new oracle client. – thatjeffsmith Oct 09 '19 at 16:08