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?
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.