Xref: alice comp.databases.oracle.server:33471
Path: alice!news-feed.fnsi.net!news.new-york.net!newsfeed.metronet.de!RRZ.Uni-Koeln.DE!usenet
From: Martin Trzaskalik <martin@ernie.mi.uni-koeln.de>
Newsgroups: comp.databases.oracle.server
Subject: Re: beginner: LONG, BLOB, CLOB
Date: Wed, 11 Nov 1998 09:26:16 +0100
Organization: Regional Computing Center, University of Cologne
Lines: 19
Message-ID: <36494A28.5B5AEFA0@ernie.mi.uni-koeln.de>
References: <36483CA4.EB770DCA@ernie.mi.uni-koeln.de> <3648AF3A.A0B035A6@exesolutions.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 4.5 [en] (Win95; I)
X-Accept-Language: de,en,fr
To: dmorgan@exesolutions.com

> > 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