Re: Flat File Data Load

From: Carlos Netto <Carlos.Netto_at_ibase.org.br>
Date: Fri, 14 Oct 94 16:39:00 -0300
Message-ID: <2aa.546.846%mpcbbs_at_ibase.org.br>

On 14 Oct 94 04:39pm, Rob Gibson wrote to ALL:

 RG> Newsgroup: comp.databases.oracle
 RG> Organization: IPL InterNetNews site

 RG> Does anyone know how I can take a fixed field length SDF type ascii 
 RG> file and use it to insert into a an Oracle table?  Sybase has a neat 
 RG> little utility called BCP that will let you import ascii data very 
 RG> easily.  Is there something similar for Oracle?  I looked in the FAQ, 
 RG> but found nothing about this.  Thank you in advance for any light you 
 RG> might shed. 

You can use SQL*Load. It's very fast. Read about it on Oracle's manuals.

bye,

   ----->>>>>>>>>>>> Don't reply. Reply will not work! <<<<<<<<<<<<<<----

---

| Carlos Augusto Leite Netto | Voice : +55.192.51.1153 |
| Software Design Informatica | Fax : +55.192.54.6518 |
| Oracle VAR | e-mail : carlos.netto%mpcbbs_at_ibase.org.br |
| Software Development & DBA | FidoNet: Carlos Netto [4:801/31] |

|---------------------------------------------------------------------------|


|  Softex 2000 member           | Brazil, Sao Paulo state, Campinas city    | 


=============================================================================

  ----->>>>>>>> I'll register my Silver only after bug fixes. <<<<<<<-----

• Evaluation copy of Silver Xpress. Day # 112 --- via Silver Xpress V4.01P [NR]

  ---

User Name: Carlos Netto - ( %mpcbbs_at_ibase.org.br ) This message was processed by RAuucp from Merlin Systems Inc.

---

Received on Fri Oct 14 1994 - 20:39:00 CET