Re: Insertion of files into a table in an Oracle databse.

From: Joel R. Kallman <jkallman_at_us.oracle.com>
Date: 1997/05/13
Message-ID: <3379e5bc.2499203@newshost.us.oracle.com>#1/1

On 12 May 1997 15:43:41 GMT, "Prestwick Circuits Ltd." <mckinnonj_at_prestwick.co.uk> wrote:

>Hi
>
> I am working on transferring data from our old business system to our new
>Oracle database. I have never used Oracle before, although I do have
>experience of Ingres. The main problem I am having is bulk loading data
>into tables. In Ingres the command
>
> copy table <Tablename>(attr1=format1,attr2=format2.....)
> from "filename"
>
> does this for you. Is there an equivalent in Oracle or am I missing
>something really obvious. Any assistance would be greatly appreciated.
>
>Best Regards
>
>James McKinnon

James,

If you have any way of extracting this data out of Ingres into a text file, putting it in comma-delimited, tab-delimited, or fixed-width column output, you should be able to use SQL*Loader to then load these files directly into your Oracle database.

SQL*Loader is covered extensively in the Oracle Server Utilities Guide, part of the documentation set.

Thanks!

Joel

Joel R. Kallman          Enabling the Information Age through
Oracle Government                Network Computing!
Bethesda, MD                  http://govt.us.oracle.com
jkallman@us.oracle.com          http://www.oracle.com

---

The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. Received on Tue May 13 1997 - 00:00:00 CDT