One solution is to create several Oracle tables, and disperse the data among
the tables. Each table would consist of the Primary Key and the Long. How
Long is the Long? Oracle 7.x VARCHAR2 will handle up to 2K in length 8.x
will handle 4K. If VARCHAR2 is sufficient, use it instead.
Carlserra <carlserra_at_hotmail.com> wrote in message
news:81c3m3$s1m$1_at_lola.ctv.es...
> Hi:
>
> In SQL Server I can use more than one MEMO or TEXT datatype to introduces
> great amount of information, but in Oracle I only can use one LONG
datatype.
> I want to export several tables from SQL Server to Oracle but in SQL
> server´s tables there is two or three or more TEXT datatype per table.
What
> can i do?, because the export process must be automatic by a program, not
by
> personal election.
>
> Thanks
>
> Please response me to my personal e-mail: carlserr_at_teleline.es
>
>
Received on Mon Nov 22 1999 - 14:08:52 CST
