1. Export Forfor Data to ASCII file , and import by SQLLoader
2. Third Party tools (like PB Pipeline) to transfer data between 2 database .
2. Third Party tools (like PB Pipeline) to transfer data between 2 database .
打开dbf文件,然后使用下面的语句:
copy to c:\a.txt deli
将其输出到一个文本文件,子段之间是以逗号隔开的然后使用sql*loadder将其导入oracle
还可以用操作系统定时功能。
再用SQL*LDR 导入数据库