Re: Transferring a table to Oracle:

Maybe not the right answer, but are you logging on as the owner of the table?

-Brian

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 Fri Nov 10 2000 - 05:13:00 CET