RE: import table from SQL server To Oracle

From: Kevin Lange <kgel_at_ppoone.com>
Date: Wed, 01 Aug 2001 12:09:36 -0700
Message-ID: <F001.0035C8EB.20010801122306@fatcity.com>

Probably a couple .... but two that come to mind are

1. Dump the data from the SQL Server table into a flat file then use SQLLDR to load it into Oracle.
2. ODBC App to load from one and into the other.

-----Original Message-----
Sent: Wednesday, August 01, 2001 2:31 PM To: Multiple recipients of list ORACLE-L

Dear DBAs

is there any tool available to import table from SQL 2000 server To Oracle 8.5 online or by other way.

Mitchell

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mitchell
  INET: mitchell_at_comnet.ca

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Kevin Lange
  INET: kgel_at_ppoone.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Aug 01 2001 - 14:09:36 CDT