| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Insertion of files into a table in an Oracle databse.
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
![]() |
![]() |