Solved

Export Access to Oracle

Posted on 1998-08-06
4
300 Views
Last Modified: 2006-11-17
I exported a table from access to oracle. The name of the table in access is in mixedcase : t_Projects.
This works ok, i can attach the table in access, but in oracle i cannot select or drop the table.
If i do the same with T_PROJECTS i can select or drop the table in oracle. Now the question : how can i drop the table  t_Projects in oracle ?
0
Comment
Question by:jan_l_keersmaekers
4 Comments
 
LVL 3

Expert Comment

by:MorFF
ID: 1958285
Oracle is not keen on mixed case for database objects.

I would suggest that you change the Access table to be all uppercase (or adjust your export to make it all uppercase) and this should resolve the problem.

Cheers - MorFF
0
 

Author Comment

by:jan_l_keersmaekers
ID: 1958286
Righto, but how do i delete this oracle table which name is in mixed case : drop table t_Projects results in : table not found

0
 
LVL 1

Accepted Solution

by:
jonty071798 earned 100 total points
ID: 1958287
You need to delete the table using the complete schema name e.g. username.tablename

drop table scott.cust
0
 

Expert Comment

by:Bolonio
ID: 4986060
You have to export the table with Uppers.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question