It is true that after transfering tables from Access into Oracle you
have to enclose names of some tables in quotes. However, with Access 97
I was able to transfer all tables but with Access 2000 wont to transfer
them all!
--
Stjepan Brbot <Stjepan.Brbot_at_ZG.HiNet.HR>
"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message
news:3c5ee67a$0$18472$afc38c87_at_news.optusnet.com.au...
> It's hard!
>
> I bet a lot of those error messages were for tables that had
> auto-incrementing sequences in them: since Oracle and MS data types
don't
> correspond 1-for-1 (and auto-sequences are a classic
no-corresponder!), you
> do get problems. Last time I did it, I went through the entire Access
> database renaming every column so that names were all in uppercase.
Same
> for the tables themselves (otherwise, you have to enclose your table
names
> in quotes when you start running queries - select * from 'emp' for
example).
> Also, any autoincrementing sequence was replaced with a boring old
number
> field (and triggers had to be hand-crafted afterwards to populate the
> relevant fields in Oracle). Quite hard work.
>
> Oracle used to supply a conversion utility, but you had to pay for it,
and
> I've forgotten what it was called, and don't know whether it is still
> current (someone here will know). I tried it once or twice: you still
have
> to do quite a lot of work by hand afterwards, even so.
>
>
> "Stjepan Brbot" <Stjepan.Brbot_at_ZG.HiNet.HR> wrote in message
> news:a3mmbq$d314$1_at_as201.hinet.hr...
> > What is the easiest way to transfer Microsoft Access 2000 database
into
> > Oracle7 (7.3.4) or Oracle8i (8.1.7) database? I have tried Microsoft
> > ODBC and original Oracle's ODBC drivers but without success! I only
get
> > some strange error messages! Sometimes, with some tables it works
but
> > not with all tables.
Received on Mon Feb 04 2002 - 20:12:08 CST
