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