Re: Map MS Access Datatypes to Oracle 8i

From: Dmitry <support_at_ispirer.com>
Date: Thu, 5 Apr 2001 13:08:17 +0300
Message-ID: <9ahg6k$56pue$1@ID-75577.news.dfncis.de>

Hi,

Use NUMBER(10) for Access LONG, NUMBER for Double and CLOB for Access MEMO.

Best regards, Dmitry.

--
----
http://www.ispirer.com - Database migration tools and services for Oracle
and IBM DB2.
http://www.ispirer.com/chyfo.html - Tool exports data to CSV flat file,
generates CREATE TABLE, CREATE INDEX scripts for Oracle and control files
for SQL Loader.


"Martin Doering" <doeringm_at_gmx.de> wrote in message
news:3acb2b0e.201421548_at_news.mn.man.de...


> Hi!

>

> Where did I find information, how to map MS Access datatypes to Oracle

> 8i? I did find an article at MetaLink, but this a very old information

> from 1996 (URL in one line):

>

>

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab
ase_id=NOT&p_id=1024264.6


>

> I'm interested especially in the following MS Access number datatypes:

>

> Number(Double) - 8 bytes

> Number(Long) - 4 bytes

> Memo - (should I use long or long raw?)

>

> ---

> Martin Doering

Received on Thu Apr 05 2001 - 05:08:17 CDT