Oracle SQL loader references

Question

Can you guys give me some good references on Oracle SQL loader. I did Google, none of the search I found was useful

Can I have some more references on the Sql Loader? – Arup Rakshit Jan 12 '13 at 05:36 — Arup Rakshit, Jan 12 '13 at 05:36
searching on google for example? – Florin Ghita Jan 14 '13 at 06:54 — Florin Ghita, Jan 14 '13 at 06:54

score 3 · Accepted Answer · answered Jan 11 '13 at 21:47

3

The loader is covered in the Database Utilities book, which quite well written: http://docs.oracle.com/cd/E11882_01/server.112/e22490/toc.htm

Personally, I'd use External Tables instead of SQL*Loader nowadays...

answered Jan 11 '13 at 21:47

wolφi

1

The advantage of SQL*Loader is, that it can be used from a client. For external tables you have to copy the input file to the server which is not always possible. – Jan 11 '13 at 21:50
@a_horse_with_no_name: Yes, of course. Some things can't be done with the loader, some things can't be done with external tables. But if you are new to the topic, the loader, it's control and log files are a lot to learn compared to the rather simple (and fast) external tables... – wolφi Jan 11 '13 at 22:00
Isnt't the control file for an external table the same as a control file for SQL*Loader? – Jan 11 '13 at 22:01
1

Firstly, it's stored in the database, not somewhere on somebodies client. Secondly, it describes only the format of the file. Transformations and id generation is done in proper SQL instead of some funny extra language... – wolφi Jan 11 '13 at 22:06
Another difference I recall is that external tables could not deal with stream data in 10.2 at least -- EOL records were required I believe. – David Aldridge Jan 11 '13 at 22:54
The preprocessor should be able to handle this? But this is getting silly. OP asked about a first reference to documentation! – wolφi Jan 11 '13 at 23:05

score 0 · Answer 2 · answered Aug 28 '19 at 10:54

Below are the some useful references for SQL*Loader-:

Last but not the least, most helpful frequently asked questions about SQL*Loader.

2 Answers2