Re: Transferring a table to Oracle:

Yep. I had this one too.

Access builds the table on Oracle with upper and lower case on Oracle. When you go to Oracle it does not seem to be there. When you look in dba_objects it is there. Drop the table in Oracle making sure that you specify the table name in quotes so that it will find it. Recreate the table in Oracle so that it is not case sensitive. Then insert the records from Access to the Oracle table through ODBC.

Joe

"Andoni OConchubhair" <andoni_at_staff.tutticom.com.NOSPAM> wrote in message news:3A0AE986.2A8AC079_at_staff.tutticom.com.NOSPAM...
> Hi,
>
> I am using Access 2000 and Oracle 8i (for Linux)
> I am trying to move a table over my ODBC connection from my Access
> database to my Oracle database.
>
> I have set up a working ODBC connection and this part works fine as I
> have linked all the table from my Oracle database into my Access
> database and I can see their info fine.
>
> I am following the steps in the Access help pages about transferring to
> oracle and I follow the steps with no problems at all.
> But: when I then go to my Oracle database and try to select from the
> table I have moved across it prevents me saying the table does not exist
> (not that it is empty). On the other hand there is an entry for the
> table's name in the user_tables table.
>
> Please help if you have seen this before etc. Any and all ideas are
> welcome.
>
> Thanks in advance,
> Andoni OConchubhair
>
Received on Wed Nov 15 2000 - 09:09:23 CET