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

Home -> Community -> Usenet -> c.d.o.server -> migrating access97 to oracle73 with many memos in one table

migrating access97 to oracle73 with many memos in one table

From: d_b <d_brammen_at_yahoo.de>
Date: Sun, 14 Nov 1999 13:24:07 +0100
Message-ID: <382EA9E7.7FB4C8EA@yahoo.de>


Hi there!

Although I scaned this discussion group and the oracle one I don't have any idea to go on. My Access database has some tables with ten or more memo fields. I tried the Migration Tool from Oracle 73 but beside the point no data in this fields is longer than 512 bytes it crashes because "there can be only one long datatype per table". Using ODBC to connect to oracle and export the tables manually there is useless - same error.
Does anyone have a good idea how I can get my data into oracle? The way may be strange, important is that it is working.

Thanxs, D. Received on Sun Nov 14 1999 - 06:24:07 CST

Original text of this message

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