hi guys
quick question....
can i use sqlldr in sql/plus environment
if yes..how can i import flat file to oracle
using sqlldr in sql/plus environment
...what is the syntax
thank you guys
Printable View
hi guys
quick question....
can i use sqlldr in sql/plus environment
if yes..how can i import flat file to oracle
using sqlldr in sql/plus environment
...what is the syntax
thank you guys
sqlldr is a command line utility, run from the operating system, not from within SQL*PLUS. In NT/2000, just open a command window and type sqlldr user/pwd@db mycontrol.ctl and watch the magic!
Note: I am being flippant. Study the docs to understand the control and data file requirements/creation and options. Post questions here and I'll try to help.