Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Facing problem after table structure changed

CKLPMar 26 2010 — edited Mar 31 2010

Hi everyone,

i am facing some problem in OWB.I am new to OWB.hence need some help in solving this.

i will give you an exampleof my prob.i have got three table emp1,emp2,emp3 .all of them has identical structure as emp.
we get data in emp1 table from there using OWB we push data to emp2 and from there to emp3.
This was working fine.

Now we have changed data type of column ename varchar2(10) to varchar2(25) in every table[DONE FROM Toad].

after this change data is not getting inserted into these table from OWB.IF You check audit browser it says no data found error occurred.Do we need to make any change in OWB after a table structure change?

Pls let me know if you anyone could help me out in this.

Many Thanks,
cklp.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 28 2010

Added on Mar 26 2010

#data-warehousing, #warehouse-builder

8 comments

1,875 views