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 11.2.0.2 database and I was trying to import into 11.2.0.1. I don’t really expect that to work flawlessly, but a better error would have been nice. Patched my local DB up to 11.2.0.2 and everything worked great. Hopefully google will lead someone here and save them some time…
Like this:
One blogger likes this post.
RJ said
Tyler, I’d suspect the character set, is the character set same/compatible between the source and destination db?