Importing data

[Sandy]

I have just recently started working with Oracle 8i and have a SQL Server
background. When we wanted to import large amounts of data into a table
in the db we sould use a "bulk copy". Oracle doesn't appear to have anything
like this.

Can anyone give me a tip on taking data in a flat file and importing into
an Oracle db.

Thanks!

[dnagel]

it does, but its a command line (dos) program...

Can't recall the name off-hand...

D.

"Sandy" <smbcat@nol.net> wrote in message news:3ce3afad$1@10.1.10.29...
|
| I have just recently started working with Oracle 8i and have a SQL Server
| background. When we wanted to import large amounts of data into a table
| in the db we sould use a "bulk copy". Oracle doesn't appear to have anything
| like this.
|
| Can anyone give me a tip on taking data in a flat file and importing into
| an Oracle db.
|
| Thanks!

[Guy Smith]

Sandy,

You are looking for the SQL Loader utility.

http://www.orafaq.com/faqloadr.htm

O'Reilly publishes a book on the utility if the Oracle documentatoin is not
enough for you.

Guy Smith