DSXchange

Tried importing table definiton from oracle db using plug in metadata definitoon and orchestrate definition in datastage version 9.1.

When i load the metadata in the oracle connector target stage column size is increasing from 255 to 600 , has any body faced the same situation?

I literally have more than 200+ columns i dont want to manually change this for each and every column.

This is almost certainly because you have NLS enabled and Oracle is reporting the byte size (not the character size) for its VarChar2 and Char storage. If you just leave things as they are imported it will work fine.

Thanks for the information.