OWB 11g R2, oracle DB 11g
For some reasons.... I have changed my table definitions in the DB level, added few columns and loaded the data using some scripts into this table. I have this table in OWB (old version without these extra columns), is there anyway to synchronize the table definitions from DB to OWB? or I have to do all the changes in OWB again? If I deploy by changing the table in OWB manually then deploy, I guess it does not allow to upgrade, but if I do replace, there is a risk of loosing the data.
Is there any way to do this without loosing the data?
You have to reimport the table into OWB (i.e by right clicking the module where the table resides -> select import 'from database' )
Then synchronize this table in the maps that are using this table.(Inbound synchrinization).
Thanks Reddy for your valuable response, will it applicable even though the table has been created in OWB first then deployed? because this is what I read while doing some research.
Yes, this is applicable whether you have created the table through OWB or DB, if you have made the changes for the table at DB level you can reimport the table into OWB and synchronize, Otherwise you need modify the object in OWB manually which will be a cumbersome process if the changes are huge.
Thanks and Regards,