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 ?
jan_l_keersmaekersAsked:
Who is Participating?
 
jonty071798Connect With a Mentor Commented:
You need to delete the table using the complete schema name e.g. username.tablename

drop table scott.cust
0
 
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
 
BolonioCommented:
You have to export the table with Uppers.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.