>I am currently in the process of upsizing our FoxPro 7.0 database to Oracle 9
>
>I start by creating the table in oracle
>making a remote view of it
>and then I use
>SELECT * FROM table INTO ARRAY array
>and
>INSERT INTO table FROM ARRAY array
>
>Is there a faster way
>
>Some of my tables have reached the limit of 2 Gigs.
>Probably wont be able to use arrays for those...
>
>Thank you for your help
>
>Cicilia
Hello Cicilia
I would advice to use sql paththroug , not remote views in manual transaction mode
sqlsetprop(con,'transaction',2)
do insert in circle and make sqlcommit in 100-200 records, it will increase the speed in many times
I also advice to use sqlprepare for insert
And finaly , two years ago I wrote on VFP my own instrument to work with Oracle and Interbase , to make import ( oneor full directory with tables) to server and back,to see server tables structure, just modify it
Interface is aufull, not butified, but can be improved
I can mail it to you, if you wish
Best wishes, Vladimir Zhuravlev
MVP-2006-2011, PHD in Math and Physics ,
host of
www.foxclub.ru,
VFP lector at Interface and Microinform companies
Head science researcher of VNIIA Rosatom.