Unanswered: Data Load from Informix to Oracle Porblem
I need to load millions of data from Informix 7.3 to Oracle9i.
I was thinking of using Sql loader to load the data so the data from
informix should come in as a flat file .
For eg a CSV file now the flat file has a restriction on its size when
the data is huge i doubt if its going to truncate the data which means
i don't get the entire data on a CSV file..
Say if I have t1 table and t2 table exported and converted to csv file for eg t1.csv and t2.csv.
Now if I create an external table say ext_tab with two csv files its possible
but the data should be similar and will be appended for eg
USA,Unites States of America,English
then External table
Ext_table will contain 7 rows in that table like
Col1 Col2 Col3
ENG England English
SCO Scotland English
IRE Ireland English
WAL Wales Welsh
FRA France, Frencha
GER Germany German
USA Unites States of America English
But if i wanna make create external table such that data for
col1,col2,col3 should come from t1 and col4,col5,col6 should come from t2.
Is it possible to make oracle understand that .