[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 335
  • Last Modified:

Export Access to Oracle

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
jan_l_keersmaekers
Asked:
jan_l_keersmaekers
1 Solution
 
MorFFCommented:
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
 
jan_l_keersmaekersAuthor Commented:
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
 
jonty071798Commented:
You need to delete the table using the complete schema name e.g. username.tablename

drop table scott.cust
0
 
BolonioCommented:
You have to export the table with Uppers.
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now