Home » RDBMS Server » Server Utilities » Exporting from Access to Oracle
Exporting from Access to Oracle [message #363158] Fri, 05 December 2008 04:35 Go to next message
Messages: 1
Registered: December 2008
Junior Member
Hi all,

nowadays we are dealing with an issue of exporting access tables to oracle 11g.Briefly, the problem is our former developers had defined columnnames with space characters in access tables,as you know they are not valid in oracle db.After spending hours on internet we found out that we can export tables to oracle with the same column names if we put a quotation mark (") just before and after the column name which means a column named [Customer Name] in access is gonna be changed to "Customer Name".It looks okey but still looks like an amateur ,daily solution.Dou you know any other solution for our problem and also is the putting quotation marks(") a supported solution for oracle's side.

Thank You

Re: Exporting from Access to Oracle [message #363159 is a reply to message #363158] Fri, 05 December 2008 04:43 Go to previous message
Messages: 20847
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quotation marks will "solve" the problem; however, I'd try to avoid such a solution as you'll ALWAYS have to use double quotes when dealing with these tables/columns. The same goes for lowercase object names (can be done using the double quotes, but ... that's absurd, most of the time).

Did you, perhaps, check Oracle Migration Workbench? A free Oracle GUI product called SQL Developer might help you migrate MS Access database to Oracle; check the Migration Workbench forum - perhaps you'll find something interesting.
Previous Topic: ORA-00600 while data insertion through SQLLDR
Next Topic: exp user in oracle 8i and import it in oracle 10g
Goto Forum:

Current Time: Fri Oct 28 11:40:06 CDT 2016

Total time taken to generate the page: 0.11270 seconds