Tyler Muth’s Blog

Technology with a focus on Oracle, Application Express and Linux

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

3 Responses to “awrload.sql > ORA-12899: value too large for column….”

  1. RJ said

    Tyler, I’d suspect the character set, is the character set same/compatible between the source and destination db?

  2. There are system table defination change’s. Normally when new features are added … there are more and more possiblity of system table defination changed

  3. check this said

    Życzliwe pozdrowienia i podziękowania za artykuł – świetnie się go czyta

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: