Re: Uploading data into Oracle

bonanos_at_yahoo.com wrote:
>
> Hi
>
> > What is the best tool for uploading data into oracle?
> > We are considering Erwin or perhaps TOAD.
> > Anyone had experience with these?
> > Which is better?
> > If not perhaps another tool?
> >
> > Seems like imp and exp are mainly used by SYSTEM or DBA.
> >
> > I tried insert statement but seems like you have to load at 10,000 record
> > segements and tend to be slow in generating the sql statements.
> > It took me a few days just to generate and load ~300,000 record database.
>
> The main tool to use is sql loader (sqlldr80) this is used to load delimited
> flat files
 

We (Hanlon Consulting) have recently made an evaluation copy of our data loading tool,
DataMill, available for download. It is a command-line tool similar to SQL*Loader
but it allows for arbtrary SQL and PL/SQL rather than straight inserts. In terms of
speed, it is slower than direct load but much faster than conventional load.

You can get it from http://www.hanlon.co.uk/. We'll announce it properly sometime
shortly.

Hope this helps,
Steve.

-- 
Stephen Hanlon...................Email :  steve_at_hanlon.co.uk
Hanlon Consulting Ltd............Phone : +44 (0)797 006 7750
.................................Fax   : +44 (0)870 056 7283