Re: Oracle 7.3 and Foxbase

From: McMalo <McMalo_at_HotMail.com>
Date: 1999/03/30
Message-ID: <bg8M2.1944$Ic2.15411_at_newscene.newscene.com>#1/1


Nice to know a DBA point of view.
Really, I am to use to consider the database for myself, and part of my own PC
So if I cause a big load, I just take a coffe break. I will keep it in mind the next time
Thanks

>I would not use Visual Foxpro for the migration. You are best off creating
>a delimited file and using SQL*Loader.
>
>Why? Because Visual Foxpro will generate an INSERT INTO <TableName>
 COLUMNS
>(<ColumnList>) VALUES (<Values>) statement and a commit for every single
>row. This chews up the SGA memory and the performance is extremely poor.
>Updates seem to be even worse. Visual Foxpro is a good tool for OLTP
>programs, but is definitly not the way to go when it comes to large inserts
>or updates. Do it this way and the DBAs will not be too happy with you.
>
>Shawn
>
>
>McMalo <McMalo_at_HotMail.com> wrote in message
>news:ZdvK2.9865$gn1.36241_at_newscene.newscene.com...
>> Use Visual foxpro . You can connect to Oracle via ODBC, create a remote
>> view,
>> open it, open you foxbase table (by the way, is dbase format) in another
>> work area , an the issue a
>>
>> select <oracle-remote-view>
>> append from <foxbase_table_name>
>> =tableupdate(.t.,.t.)
>> and presto!
>>
>> don't forget to set up the remote view as updatable.
>>
>> Gazelle wrote in message <7dct7h$588_at_news_nt.cc.ege.edu.tr>...
>> >Hi All,
>> >
>> >We are using the database Foxbase in our applications. But now our
 system
 is
>> >changing. We are going to start using Oracle 7.3
>> >Is there any way to transfer data from Foxbase to Oracle 7.3.?
>> >Please, if somebody can help me out by providing the full way out. I'll
 be
>> >thankfull
>> >
>> >Regards
>> >Melike Öztürk
>> >
>> >
>>
>>
>
>
Received on Tue Mar 30 1999 - 00:00:00 CEST

Original text of this message