PDA

View Full Version : Importing data files

lfb
10-29-2003, 08:03 AM
I'd like to fill my Oracle tables with content of various text files.
It seems that the BULK INSERT command does not exist with Oracle ?

How could I import my datas ?

Thanks,
Laurent.
Volker Hetzer
10-29-2003, 08:10 AM
"lfb" <lfinet_baron@hotmail.com> schrieb im Newsbeitrag news:bnoofa$ku7$1@s1.read.news.oleane.net... I'd like to fill my Oracle tables with content of various text files. It seems that the BULK INSERT command does not exist with Oracle ? How could I import my datas ?
You could start by figuring out which newsgroup is appropriate for this instead of crossposting
to all three.

Greetings!
Volker
Jan Gelbrich
11-04-2003, 03:24 AM
"lfb" <lfinet_baron@hotmail.com> schrieb im Newsbeitrag
news:bnoofa$ku7$1@s1.read.news.oleane.net... I'd like to fill my Oracle tables with content of various text files. It seems that the BULK INSERT command does not exist with Oracle ? How could I import my datas ? Thanks, Laurent.

SQL*Loader should be the tool for You - it comes with Oracle.

And please do not think that IMP or BULK INSERT or SQL*Loader work the same.
They all have quite different purposes.

More details on tahiti.oracle.com

hth, Jan

MyLounge.com Site Map
Forum: Cars, Cell Phone, Database, Games, Home Improvement, IT, Music, School, Sports, Web Design, Web Server, Weight Loss

The MyLounge.com forum is intended for informational use only and should not be relied upon and is not a substitute for any advice. The information contained on MyLounge.com are opinions and suggestions of members and is not a representation of the opinions of MyLounge.com. MyLounge.com does not warrant or vouch for the accuracy, completeness or usefulness of any postings or the qualifications of any person responding. Please consult a expert or seek the services of an attorney in your area for more accuracy on your specific situation. Please note that our forums also serve as mirrors to Usenet newsgroups. Many posts you see on our forums are made by newsgroup users who may not be members of MyLounge.com Term of Service