Re: Transferring a table to Oracle:

Alternatively you can just access the table by enclosing all reference in double quotes.
ie
sql> desc "ThisTable"
sql> select "MixedCased", "Names" from "ThisTable"

You probably want to convert to uppercase as this becomes a pain after a while..

joe nuhfer wrote:

> 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
> >

--
Brett England         | brett_at_recalldesign.com   | www.recalldesign.com
Information Architect | Direct: +61 8 8217 0562  | Mobile: 040 858 1102
Recall Design Pty Ltd | Tel:    +61 8 8217 0500  | Fax: +61 8 8217 0555
                      | 53 Gilbert Street, Adelaide SA 5000,  AUSTRALIA