How to Import foxpro DBF data in Oracle 8.0

In this forum Oracle Applications DBA's, System Administrators & Developers can share their knowledge/issues.
Post Reply
kamran.it
Posts: 34
Joined: Tue Aug 01, 2006 7:43 am
Location: Pakistan

How to Import foxpro DBF data in Oracle 8.0

Post 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
admin
Posts: 2063
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post by admin »

Export foxpro to text file and then import or use ODBC. thanks
kamran.it
Posts: 34
Joined: Tue Aug 01, 2006 7:43 am
Location: Pakistan

Post 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
admin
Posts: 2063
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post by admin »

Pl check the extensions of your rc file,

control = c:\rc.ctl
SQL*Loader-500:Unable to open file (rc.txt)
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest