This is also by far the easiest way I have found of doing this. There are a
couple of things to bear in mind here though:
1) If you have two "large" data fields in the same table in SS, the
transformation sometimes tries to create the Oracle tables with multiple
LONG data types - which can't be done.
2) If you allow the DTS service to create all of the table etc., then the
table names will be created in lower case format - so when dealing with the
tables you will have to enclose them in "double-quotes". You may want to go
through all of the tables and alter table table_name rename to TABLE_NAME.
My 0.02p
Mark
-----Original Message-----
Dave
Sent: Wednesday, August 01, 2001 09:04
To: Multiple recipients of list ORACLE-L
You can use the DTS function of SQL Server 2000. It's a fast and easy way
to move data.
Dave
-----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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Farnsworth, Dave
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Mark Leith
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
