Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: MS SQL Server to Oracle Problem

RE: MS SQL Server to Oracle Problem

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Thu, 29 Nov 2001 06:11:14 -0800
Message-ID: <F001.003D05A9.20011129054058@fatcity.com>

What is stored in the SQLServer table? Maybe you could look at creating the field as some form of LOB? Maybe the data will fit in to a large VARCHAR2 field? With databases like Access and SQLServer you can have multiple columns in a table of datatype MEMO or whatever the SQLServer equivalent is - I forget.. The corresponding one for Oracle is usually made LONG, but sometimes you can get away with a VARCHAR2(4000).

HTH Mark

-----Original Message-----
S.Jyotinarayan
Sent: 29 November 2001 09:06
To: Multiple recipients of list ORACLE-L

Hi all,

I am trying to Import a database Design and Data into Oracle from MS SQL Server 2k. All tables have been imported excepting for one.

Error message:
ORA: 01754: a table may contain only one column of type LONG

What should I do to be able to import the table into Oracle?

Thanx in advance,
Jyoti.



Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: S.Jyotinarayan
  INET: ncjyoti_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: Mark Leith INET: mark_at_cool-tools.co.uk 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 Thu Nov 29 2001 - 08:11:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US