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
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers