>How to import some flat file from IBM AS/400 to Oracle database?

There are a number of ways or tools you could use.
You could.
-Read the text file in VFP and then use SQLEXEC() to instert the data.
-You could use the SQLLoader tool on Oracle.
-You could use PL\SQL - utl_file package to read the text file and insert the data into you tables.