Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: beginner: LONG, BLOB, CLOB
> 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