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 184.108.40.206 database and I was trying to import into 220.127.116.11. I don’t really expect that to work flawlessly, but a better error would have been nice. Patched my local DB up to 18.104.22.168 and everything worked great. Hopefully google will lead someone here and save them some time…