Unable to load the data of clob type in oracle to text type in postgres
rvAug 16 2012 — edited Aug 16 2012I am unable to load data from oracle to postgres through odi 11g.
The datatype in oracle is clob and its corresponding in postgres is text.
When i am loading the data then there is no error in the operator but when i checked the data in the postgres, the data there was junk data.
First the data is loaded into the c$ table from oracle and then then data from c$ table is loaded into the main table of the postgres.
c$ table is being made in the postgres as the staging area is target.
Please reply