Re: Convert Access tables to Oracle

From: Chris Laatinen <cl_at_nospam.08002go.com>
Date: Sat, 1 Sep 2001 10:40:32 +0100
Message-ID: <MPG.15fabd705195a5c3989683_at_news.08002go.com>


In article <5f875ee.0108312248.49fed20b_at_posting.google.com>, nausicaa4_at_caramail.com says...

Use oracle migration workbench, available free on technet.oracle.com!

Hope this helps...

CL

> Hi,
>
> When i have to import Access to Oracle , I use DTS (Microsoft
> Software ) which
> is installed with The sql server client (you can do the same thing
> with Sql Server Entreprise Manager .
> Be carrefull , sometimes , the data format memo is converted in long
> If you want to transform into char
> Put in a PL/SQL bloc:
> L_variable long
> C_variable varchar2(4000)
> C_variable :=substr(L_variable,1,4000)
>
Received on Sat Sep 01 2001 - 11:40:32 CEST

Original text of this message