Re: Uploading data into Oracle

Next time, and assuming you're using 7.0 or above, the preferred way is to build the tables prior to recreating indexes.... Whole lot smarter that way. Check the OraclePress DBA book, and perhaps other sources regarding the INDEXFILES parameter of IMPORT.

Dave Van Zandt

Venkatesh Kumar wrote:
>
> Hi,
> Try Sql*Loader. Sql*Loader comes as part of the oracle database and
> you should be able to load data from files real fast. Iam not sure
> what your application is. If you have to do data cleanup and
> translation as part of the load, you may want to check out a tool
> called SMART DB from SMART DB corp in California.
> Let me know if you need more help on this.
>
> Cheers
> Ven Kumar
> ===========================================================
> internet : vkumar_at_fundu.com
> URL : http://www.fundu.com
> ===========================================================
> Do you want to be a fundu ? Check out http://www.fundu.com
> ============================================================
>
> MAMASTA wrote:
>
> > 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.
> >
> > There must be a much easier way than this....
>
>

-- 
Dave Van Zandt
(work) david.vanzandt_at_alcoa.com
(pers) dvanzandt_at_iquest.net  http://members.iquest.net/~dvanzandt