How to load data from Foxpro DBF file into Oracle Database from SQL prompt
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