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…
RJ said
Tyler, I’d suspect the character set, is the character set same/compatible between the source and destination db?
database services said
There are system table defination change’s. Normally when new features are added … there are more and more possiblity of system table defination changed
check this said
Życzliwe pozdrowienia i podziękowania za artykuł – świetnie się go czyta