Re: Loading data - SQL*LOADER or ???
Date: 1996/05/20
Message-ID: <4nq054$n8h_at_alpine.valleynet.com>#1/1
ebeth_at_universe.digex.net (Elizabeth Jones) wrote:
>General Oracle question - do many Oracle users use sql*loader, and
>if not, what other loading techniques are preferred? Is there an
>advantage to using sql*loader over writing a sql script that contains
>all your data and loading it thataways?
>--
>Elizabeth Jones .......................... ebeth_at_universe.digex.net
>"Elves seldom give unguarded advice, for advice is a dangerous gift,
>even from the wise to the wise, and all courses may run ill."
A SQL script cannot read your files on your OS system. To do that you must use either SQL Loader ( which is very fast ) or write PROC*C programs to read the file, parse and load.
Another option you may have is to use DBperl. I use SQL*LOADER and/or DBperl where appropriate. C takes too long to develop.
Jared Still, Oracle DBA
RxNet, Division of Value Health
"All opinions are mine, not my employers"
jared_at_valleynet.com
Received on Mon May 20 1996 - 00:00:00 CEST