Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed.news2me.com!feed.cgocable.net!news.stealth.net!news.stealth.net!prodigy.com!newsmst01.news.prodigy.com!prodigy.com!postmaster.news.prodigy.com!newssvr14.news.prodigy.com.POSTED!34d3422d!not-for-mail From: Karsten Farell User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.1) Gecko/20020826 X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: comp.databases.oracle.misc Subject: Re: Access to Oracle References: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Lines: 22 Message-ID: NNTP-Posting-Host: 67.117.210.172 X-Complaints-To: abuse@prodigy.net X-Trace: newssvr14.news.prodigy.com 1034271206 ST000 67.117.210.172 (Thu, 10 Oct 2002 13:33:26 EDT) NNTP-Posting-Date: Thu, 10 Oct 2002 13:33:26 EDT Organization: Prodigy Internet http://www.prodigy.com X-UserInfo1: [[PGGX_EJ[U]CQ\Y\BCBNWX@RJ_XPDLMN@GZ_GYO^RR@ETUCCNSKQFCY@TXDX_WHSVB]ZEJLSNY\^J[CUVSA_QLFC^RQHUPH[P[NRWCCMLSNPOD_ESALHUK@TDFUZHBLJ\XGKL^NXA\EVHSP[D_C^B_^JCX^W]CHBAX]POG@SSAZQ\LE[DCNMUPG_VSC@VJM Date: Thu, 10 Oct 2002 17:33:26 GMT Xref: newsfeed1.easynews.com comp.databases.oracle.misc:87673 X-Received-Date: Thu, 10 Oct 2002 10:33:58 MST (news.easynews.com) Pride wrote: > I have several data bases in Microsoft Access and I want to change to > Oracle, but I don't know if this change is easy or I have to do new data > bases. > Someone can help me please. > > > It's actually quite easy to migrate tables and data from Access to Oracle. However, you can get into trouble if you don't first take some steps in Access. For example, Access allows you to name your tables and columns in mixed case. Oracle does too ... but only if you're willing to surround them in quotes every time you use them - eg, SELECT "MixedColumn" FROM "MixedTable". You'll find your life much easier if you first convert all your object names to uppercase in Access. Then Oracle won't care if you reference them with upper or lower or mixed case - 'SELECT column' will be the same as 'select Column' or 'select COLUMN' or any other combination you care to type. Just one of the gotchas we ran into here. There may be others, of course.