Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to load data from Foxpro DBF file into Oracle Database from SQL prompt

focusharshJun 5 2013 — edited Jun 7 2013
Hello ,

I have a problem to extarct data from Fox pro DBF file into Oracle Database 9I.

From SQL prompt , i fired the below command but it show me the error.

SQL> COPY FROM SMS/SMS@ODBC:SMS TO SYSTEM/TRPL@TRPL CREATE TEST (ACODE,MOBILENO)
USING SELECT * FROM MOBILENO.DBF;

Array fetch/bind size is 15. (arraysize is 15)
Will commit when done. (copycommit is 0)
Maximum long size is 80. (long is 80)

ERROR:
ORA-03121: no interface driver connected - function not performed

kindly help me to solve this problem.
-----------
Thanks/ Regards
HARSH SHAH

ORACLE DEVELOPER
URMIN GROUP OF COMPANIES
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 5 2013
Added on Jun 5 2013
9 comments
1,434 views