Foxpro and oracle [message #9107] |
Mon, 20 October 2003 02:19 |
Rajeev Katyal
Messages: 55 Registered: April 2002
|
Member |
|
|
I have two databases...
Oracle 8 and Foxpro for dos.
I wish to compare two tables from both databases.
so what would be the best way to compare.
Should i bring foxpro data to oracle
or oracle to foxpro and then compare them.??
which option should i go for ?
and how to do it...i.e how to send oracle data to foxpro and vice a versa.
Please help
|
|
|
Re: Foxpro and oracle [message #9108 is a reply to message #9107] |
Mon, 20 October 2003 03:34 |
Gnanam
Messages: 19 Registered: July 2002
|
Junior Member |
|
|
Hi,
better u can spool all the data from Fox to a text file using the fox command (list coln1,coln2,.. > txtfile)
then
using sql*loader u can load data into oracle database then compare the tables.
regards
velou.
|
|
|
Re: Foxpro and oracle [message #9111 is a reply to message #9108] |
Mon, 20 October 2003 05:30 |
Rajeev Katyal
Messages: 55 Registered: April 2002
|
Member |
|
|
Thanks , that is fine...but i have some reason ..so i don't want to put foxpro's data into oracle.
I need some way ..whereby i can take oracle's data to foxpro.
Please help.
Rajeev Katyal
|
|
|