RE: SqlServer - Oracle transfer issues

What's returned in SQL*Plus when you "DESC TableA_at_hsodbc"?

Rich

Rich Jesse                           System/Database Administrator
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI USA

> -----Original Message-----
> From: Luc Demanche [mailto:luckyref_at_yahoo.com]
> Sent: Friday, October 04, 2002 11:18 AM
> To: Multiple recipients of list ORACLE-L
> Subject: SqlServer - Oracle transfer issues
>
>
> Hi gurus,
> I need to transfer a few tables from SqlServer to
> Oracle. I've installed Heteroegous Service between the
> SqlServer and our Oracle database according to the
> Metalink doc no : 109730.1
>
> I began the transfer between those two databases with
> this kind of statement :
> create table TableA as select * from TableA_at_hsodbc;
>
> But now I have a problem with the tables on the
> SqlServer side that contain columns of the Text
> datatype. Oracle wants to handle it as a LONG
> datatype. I received this kind of errors :
>
> ORA-00997 : illegal use of LONG database
>
> What should I do ?
>
> TIA
>
> Luc

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).