!!!data conversion problem !!! help me
Posted in 1996
Topics: Migration, Import/Export & Data Conversion
It is a big problem for us to make a conversion from IBM main fraim data into unix oracle data. Actually we did not consider data conversion progress as such a time consuming one. Our C/S system consists of two unix ORACLE servers and our data conversion procedure is explained below. Is there any point to improve our work speed, please advise us.... 1) IBM main fraim data -> UNIX machine through reel device *** We could not help using reel device since there is no file transfer program from IBM into unix. 2) UNIX raw text -> dummy table in ORACLE *** Using SQL*LOADER in this process, we have loaded data in parallel option. 3) dummy table -> source table *** Since there exist a munber of priority among tables, we had to use dummy table to load data into really used tables. Most of time of data conversion process is spent. If you have a good idea, don't hesitate to reply us. Thanks in advance.