Page 1 of 1
How to Import foxpro DBF data in Oracle 8.0
Posted: Mon Oct 02, 2006 4:26 am
by kamran.it
Dear Sir
Please let me know how can import foxpro DBF file into Oracle 8.0 there is any possibility??
Or Please tell me how can create script file from Foxpro 2.06 to Oracle 8.0.
Best regards
Kamran
Posted: Mon Oct 02, 2006 5:17 am
by admin
Export foxpro to text file and then import or use ODBC. thanks
Posted: Tue Oct 03, 2006 6:46 am
by kamran.it
Export foxpro to text file and then import or use ODBC. thanks
<i><div align="right">Originally posted by admin - 02/10/2006 : 01:17:30 AM</div id="right"></i>
I have converted data into ctl and text file but when I am importing data through SQLLDR80 unable to import showing error Please note I am using Oracle 8.0.5
I write on dos prompt
**************
sqlldr80 scott/tiger
control = c:\rc.ctl
**************
it gave me error
SQL*Loader-500:Unable to open file (rc.txt)
OSD-04002: Unable to open file
O/S Error: (OS 2) The system cannot find the file specified.
Please help
Kamran
Posted: Wed Oct 04, 2006 12:03 am
by admin
Pl check the extensions of your rc file,
control = c:\rc.ctl
SQL*Loader-500:Unable to open file (rc.txt)