Importing metadata

dj · Post by dj » Tue Dec 04, 2007 11:51 am

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

chulett · Post by **chulett** » Tue Dec 04, 2007 12:09 pm

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

dj · Post by dj » Tue Dec 04, 2007 12:14 pm

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

chulett · Post by **chulett** » Tue Dec 04, 2007 12:23 pm

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.

Ronetlds · Post by **Ronetlds** » Tue Dec 04, 2007 3:14 pm

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