[Help] Import data from text file thru sqlplus
From: Ng Sze Ho Stephen <cs_sng_at_ug.cs.ust.hk>
Date: 1995/06/04
Message-ID: <1995Jun4.103939.28688_at_uxmail.ust.hk>#1/1
Date: 1995/06/04
Message-ID: <1995Jun4.103939.28688_at_uxmail.ust.hk>#1/1
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 & TechnologyReceived on Sun Jun 04 1995 - 00:00:00 CEST