Forum Stats

  • 3,838,643 Users
  • 2,262,385 Discussions


Refresh Physical Schema in Oracle ODI 12 c

My physical schema for my target table has been changed with different data type. I am trying to see if there is a way that I can refresh this in oracle odi process. I have gone through all the attributes and changed where applicable but still my target table does not reflect correctly as per the source table. I came to know that even though I changed logical schema oracle keeps physical schema as a data store.

My question is how do we refresh this for one particular column in a table ? As you can see on attached pic, Logical schema data length attributes set to 200 but physical format is still 100 and its greyed out.

Any help would be appreciated. Thank you