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

From: Chuck Hamilton <chuckh_at_ix.netcom.com>
Date: 1995/06/05
Message-ID: <3qvign$kp8_at_ixnews3.ix.netcom.com>#1/1


In article <1995Jun4.103939.28688_at_uxmail.ust.hk> cs_sng_at_ug.cs.ust.hk (Ng Sze Ho Stephen) writes:

> 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?

Look up the sqlload command. I believe it's in the Utilities User's Guide.

-- 
Chuck Hamilton
chuckh_at_ix.netcom.com

Never share a foxhole with anyone braver than yourself!
Received on Mon Jun 05 1995 - 00:00:00 CEST

Original text of this message