Oracle-L: RE: export tables from sql Server to Oracle

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: Wed, 01 May 2002 01:28:29 -0800
Message-ID: <F001.004549E7.20020501012829@fatcity.com>

There are two ways ..

Use Procedural Gateways to get at SQL Server Tables thru Oracle and do a CTAS.
Bring the data onto a Flat file using the export utility in SQL Serer and upload to Oracle using SQL Loader.

HTH Best Regards,
Ganesh R

Tel  : +971 (4)  397 3337  Ext 420
Fax  : +971 (4)  397 6262
HP   : +971 (50) 745 6019
============================================

Live to learn... forget... and learn again.

-----Original Message-----
Sent: Wednesday, May 01, 2002 1:17 AM
To: Multiple recipients of list ORACLE-L

Hi listers,

Can someone tell me how import tables from SQLServer to Oracle.

Thanks for your help,

Ben

Do You Yahoo!?
Yahoo! Health - your guide to health and wellness http://health.yahoo.com
--

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

Author: Kader Ben
INET: kaderb_at_yahoo.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).
--

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

Author: Ganesh Raja
INET: ganesh_at_gtfs-gulf.com

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