Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Insertion of files into a table in an Oracle databse.

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

From: Aram Meguerian <aram_at_unisys.com.br>
Date: 1997/05/26
Message-ID: <01bc6977$f788e5a0$4c04dcc8@psaphos>#1/1

      If you're trying to upload sequential files, use SQL*Loader.    A complete description of its commands can be found at "Oracle7    Server Utilities Guide" (or something like it).    

-- 

                     Aram Meguerian
                     aram_at_unisys.com.br

-------------------------------------------------------------------
  TANSTAAFL - There ain't no such thing as a free lunch 
                                           by Robert A. Heinlein
-------------------------------------------------------------------
     I don't work at Unisys, it is just my Internet Provider, 
     so don't blame it for anything I have just said.
-------------------------------------------------------------------



Prestwick Circuits Ltd. <mckinnonj_at_prestwick.co.uk> escreveu no artigo
<01bc5eec$21375b20$1305c0c0_at_dneil>...

> 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
>
Received on Mon May 26 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US