I've exported from a Solaris box running 10.1.3 and now trying to import to Win2003 server running 10.1.3. I'm getting errors on all rows.
ORA-02374: conversion error loading table "STUDENT"."COURSE_TERM_TB2"
ORA-01401: inserted value too large for column
ORA-02372: data for row: TERM : 0X'200820202020202020200320202008202
I created only a tablespace on the Windows box expecting the export to define and create the tables. Looking at that original table, the TERM is defined as CHAR 3.
What kind of conversion happened and how do I fix it?