Re: WANTED: Import utility for Access to Oracle

Bruce Callen <bccallen_at_flash.net> wrote in article <01bc502f$1296f7e0$22d0b5cf_at_ultra2.teras.com>...
> I am trying to import several tables, structure and data, from Access 95
 to
> Oracle 7.3. I have tried using the export option on Access to ODBC (2.5)
> to Oracle. This moves the table over with all the fields. The problem
 is
> then if I try to set primary keys, add indexes or do anything Oracle says
> that it is not a Table/View.
>
> Is anyone else familiar with this problem?
>
> Is there any other import utilities to import an Access table to Oracle?
>
> Thank you in advance for your help
>
> -Bruce Callen
> bccallen_at_flash.net

Well I solved the problem myself. I was looking in some of the system tables like
sys.all_tables and was looking to see if there was any difference in the tables I exported form Access and the sample ones. The only difference I found was that my tables were mixed case and the sample tables were all upper case. I did a test and changed the name of one of my Access tables to all upper case and did the same for it's fields and indexes. I then exported the table and it worked. I still had to set the primary keys in Oracle.

So it appears that Oracle upper cases everything by default and with table names and fields being lower case in it's system tables it could not find the tablename.

Bruce Callen
bccallen_at_flash.net Received on Fri Apr 25 1997 - 00:00:00 CDT