awrload.sql > ORA-12899: value too large for column….
Posted by Tyler Muth on June 15, 2011
Today I tried to load exported AWR data from a recent Exadata POV via $ORACLE_HOME/rdbms/admin/awrload.sql and recieved the following error:
ORA-12899: value too large for column "SYS"."WRH$_ACTIVE_SESSION_HISTORY"."MODULE"
Searched all over and didn’t find an answer (including MOS). The issue was that the data was exported from an 18.104.22.168 database and I was trying to import into 22.214.171.124. I don’t really expect that to work flawlessly, but a better error would have been nice. Patched my local DB up to 126.96.36.199 and everything worked great. Hopefully google will lead someone here and save them some time…