DSXchange

HI,

I have been trying to import the metadata of an Oracle Table. usually when i do the import the datalength comes as multiple of 4 and the date column as timestamp.

but now i get the exact data length of oracle table and the date column as date itself
can someone explain why it is so and how to rectify the same

thanks in advance

-dj

It's a bug or 'feature' of importing via the OCI plug-in, correct it manually after doing the initial import.

Thanks Chulett!!

But there are so many jobs to be done and it would be drastic change of doing for more than 100 jobs.

please let me know is there to do any change in the NLS settings


thanks
dj

I meant you should do this before using the 'bad' metadata in any jobs. If you've already used it, then you'll need to correct all of the jobs individually. And no, NLS plays no role in this as far as I know.

Mismatch between Oracle stage and version of Oracle database? Has Oracle been upgraded with no change to existing job?