Data migration from foxpro to oracle

*****LISTENER CONFIGURATION:

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = noor)(PORT = 1521))
      )
    )
  )

SID_LIST_LISTENER=
 (SID_LIST =
  (SID_DESC =
   (SID_NAME = hsodbc)
   (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
   (PROGRAM = hsodbc)
  )
)


*****START AND STOP LSNRCTL.EXE

C:\oracle\product\10.2.0\db_1\bin\LSNRCTL.EXE

STOP

START

***** CONFIGURE ORACLE HS (HETEREGENEOUS SERVICE) AT :

HS_FDS_CONNECT_INFO = FAIZA
HS_FDS_TRACE_LEVEL = off


***** CONFIGURE TNSNAMES.ORA AT

C:\oracle\product\10.2.0\db_1\network\ADMIN\tnsnames.ora


FOX =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = noor)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = hsodbc)
    )
    (HS = OK)
  )


add odbc at system DSN :

Microsoft dBase Driver(*.dbf)

ADD CURRENT FOLDERS.

*****Note :
table name must be 8 char long.