Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Map MS Access Datatypes to Oracle 8i
you could also take a look at the migration utility for access tables that comes with 8i. The defaults it comes up with are pretty good as a rule.
-- Niall Litchfield Oracle DBA Audit Commission UK "Martin Doering" <doeringm_at_gmx.de> wrote in message news:3acb2b0e.201421548_at_news.mn.man.de...Received on Thu Apr 05 2001 - 05:36:58 CDT
> 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