Re: beginner: LONG, BLOB, CLOB

From: Dan <dmorgan_at_exesolutions.com>
Date: Tue, 10 Nov 1998 13:25:14 -0800
Message-ID: <3648AF3A.A0B035A6@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.

Daniel A. Morgan Received on Tue Nov 10 1998 - 15:25:14 CST