Re: beginner: LONG, BLOB, CLOB

From: Martin Trzaskalik <martin_at_ernie.mi.uni-koeln.de>
Date: Wed, 11 Nov 1998 09:26:16 +0100
Message-ID: <36494A28.5B5AEFA0@ernie.mi.uni-koeln.de>

> > I am currently trying to migrate from a DBase data base to Oracle
> > 8.0.5.0.
> >
> > I imported the tables from DBase into an Access 97 Database and
> > would like to use ODBC to get them into Oracle.
>
> In one word "DON'T!"

> Access is not ANSI SQL compliant and can make a horrifying mess of the
> Oracle Data Dictionary. The best thing to do would be to sit down and
> create a new ERD that takes full advantage of Oracle 8's capabilities
> and build the tables that you need from schema manager or SQL*Plus.

But how do I get the data in? SQL*Plus does not accept more than 2399 chars by line but due to the "memos" my INSERT statments are quite longer.

Is the only way to bind the ROW using the API?

Martin Received on Wed Nov 11 1998 - 02:26:16 CST