Transferring a table to Oracle:

From: Andoni OConchubhair <andoni_at_staff.tutticom.com.NOSPAM>
Date: Thu, 09 Nov 2000 18:14:31 +0000
Message-ID: <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 Thu Nov 09 2000 - 19:14:31 CET

Original text of this message