Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Please ask technical questions in the appropriate category. Thank you!

Refresh Physical Schema in Oracle ODI 12 c

User_C81BAJul 5 2021

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.
sPjdk.pngAny help would be appreciated. Thank you

Comments
Post Details
Added on Jul 5 2021
1 comment
142 views