We help IT Professionals succeed at work.

SQLLoader script

mrt1
mrt1 asked
on
Medium Priority
1,462 Views
Last Modified: 2008-03-10
Hi, I've been asked to create a UNIX script to run Oracle SQLLoader.
Has anyone got a good example of this?
I want to pass the file locations of the control file, log file AND data file to SQLLoader.
The UNIX script just needs to check that the relevant files exist, pass the information to SQLLoader (via the command line) and then check that everything went OK (i.e check for a .bad file, etc.)
Any help would be appreciated.
Comment
Watch Question

CERTIFIED EXPERT

Commented:
what should your SQLLoader do? just starting the database and listener, or initializing the database with tables and/or values?

Author

Commented:
SQLLoader needs to load a flat file into the database.
I don't like posting links, but I haven't got a lot of time. So take a look at http://www.oreilly.de/catalog/orsqlloader/examples/

Regards Mike

Explore More ContentExplore courses, solutions, and other research materials related to this topic.