Re: Import von ACCESS via ODBC

On Mon, 16 Apr 2001 18:09:01 +0200, Kay Schulz <kay_schulz_at_yahoo.com> wrote:

>Hi
>I tried to export an access table via the ODBC export
>feature into Oracle 8.1.5;
>I didn't get an error
>When I go into SQL*Plus and do
>select TABLE_NAME from ALL_TABLES;
>I see the two tables I wanted
>So I did
>select * from Books;
>Table or View not existing
>How can this be?
>If it would be empty, fine, but not existing while the other
>command told me it exists ....
>Weird.
>Please help
>Kay
>
>--
>Kay Schulz

Chech what schema it was imported into. You'll need to

 SELECT * FROM <schema>.Books;

Brian Received on Mon Apr 16 2001 - 11:30:09 CDT