Re: [Help] Import data from text file thru sqlplus

Ng Sze Ho Stephen (cs_sng_at_ug.cs.ust.hk) wrote:

: I can extract data from Sybase server by "bcp" command into text files,
: delimited by "," or space. Assuming the table definitions are the same
: in the Sybase server and Oracle server, how can I import the data into
: the Oracle server through sqlplus? Or any other means?
 

: Your kind help will be much appreciated. Thank you.
 

: --
: NAME : Stephen NG Sze-ho | Undergraduate, Year 3
: EMAIL: cs_sng_at_ustsu4.ust.hk | Department of Computer Science
: cs_sng_at_ug.cs.ust.hk | The Hong Kong University of Science & Technology

Stephen,

You can use the SQL*Loader utility provided by Oracle. This utility allows to import various formatted data, one of which is the delimiter. See your utilities guide for more details. Or email me for more.

Good Luck,
Leng.

--
Leng Kaing                                   
Dept of IT&S
VUT - Footscray Campus           __!__           Tel: +61 3 688 4368
PO Box 14428, MMC              ----o----         Fax: +61 3 688 4800
Melbourne 3000, Australia         " "            Email: leng_at_cougar.vut.edu.au