From: John Ralph <cwrmusic@erols.com>
Newsgroups: comp.databases,comp.databases.oracle,comp.databases.access
Subject: Re: Transferring a table to Oracle:
Date: Fri, 10 Nov 2000 19:33:23 -0500
Lines: 35
Message-ID: <3A0C93D3.26D34D09@erols.com>
References: <3A0AE986.2A8AC079@staff.tutticom.com.NOSPAM>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: +WooNqWXiDT3kWlTGG6CRel6k3p5d1ruCu8a3xsGdsk=
X-Complaints-To: abuse@rcn.com
NNTP-Posting-Date: 11 Nov 2000 00:35:52 GMT
X-Accept-Language:  en
X-Mailer:  Mozilla 4.61 [en] (Win95; U)


Andoni,
I actually had the same problem. I finally grabbed the SQL script to create
the table from Access and just created an empty table in Oracle.

Then, I linked the external Oracle table and just copy/pasted the records
from Access into the linked Oracle table.

Hope that helps,
John

Andoni OConchubhair wrote:

> 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