Exporting from Access to Oracle [message #363158] |
Fri, 05 December 2008 04:35 |
ofaq
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
gokhan
|
|
|
Re: Exporting from Access to Oracle [message #363159 is a reply to message #363158] |
Fri, 05 December 2008 04:43 |
|
Littlefoot
Messages: 21821 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.
|
|
|