Re: Importing an mdb file

These tools work, beware of a few pitfalls : - Autovalue / Autoincrement columns best disable these first   Then use sequences and a trigger in Oracle - Logicals - your code will need to change - Check your indexes afterwards - PK's should be OK

HTH Ted

On Thu, 26 Apr 2001 08:17:24 -0700, Steven Findlay <StevenFindlay_at_NorATek.com> wrote:

>This is a multi-part message in MIME format.
>--------------F918E18293AFC1B4AF3763E1
>Content-Type: text/plain; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>
>You can use the Oracle Migration Workbench. This tool works fairly well,
>there does seem to be some minor problems with some constraints in access.
>You could also use export from access via ODBC....
>
>Kazakis Apostolos wrote:
>
>> I was wondering if i can import an MS Access database to Oracle. If so
>> what tool do i have to use? Will the tables or the relationships be
>> changed?
>>
>> Tanks in advance
>
>--------------F918E18293AFC1B4AF3763E1
>Content-Type: text/x-vcard; charset=us-ascii;
> name="StevenFindlay.vcf"
>Content-Transfer-Encoding: 7bit
>Content-Description: Card for Steven Findlay
>Content-Disposition: attachment;
> filename="StevenFindlay.vcf"
>
>begin:vcard
>n:Findlay;Steve
>tel;cell:(250) 961-3896
>tel;fax:(250) 564-3325
>tel;home:(250) 962-0468
>tel;work:(250) 564-2236
>x-mozilla-html:FALSE
>url:www.noratek.com
>org:NorATek Solutions;Consulting/Development
>version:2.1
>email;internet:StevenFindlay_at_NorATek.com
>title:Oracle Architect
>adr;quoted-printable:;;Suite 200=0D=0A1515 2nd Ave;Prince George;BC;V2K 2B2;Canada
>fn:Steven Findlay
>end:vcard
>
>--------------F918E18293AFC1B4AF3763E1--
>

EMail: knijff_at_bigfoot.com Received on Sat Apr 28 2001 - 11:35:17 CDT