Re: Uploading data into Oracle
Date: Tue, 09 Feb 1999 12:35:29 GMT
Message-ID: <79pa2h$su$1_at_nnrp1.dejanews.com>
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
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Feb 09 1999 - 13:35:29 CET