DarrenJackson
asked on
Refresh from Metallink job error
Guys
I use oracle oem 10g I would like to use the metallink link to get the patches from oracle but everytime I run this I get the following error but I am nit sure how to move on
Updating OEM repository with latest release table data from Oracle MetaLink.
- Exception trying to access the repository. java.sql.SQLException: ORA-12899: value too large for column "SYSMAN"."MGMT_ARU_PRODUCT S"."PRODUC T_NAME" (actual: 54, maximum: 50)
Any one got any Ideas
Cheers
Darren
I use oracle oem 10g I would like to use the metallink link to get the patches from oracle but everytime I run this I get the following error but I am nit sure how to move on
Updating OEM repository with latest release table data from Oracle MetaLink.
- Exception trying to access the repository. java.sql.SQLException: ORA-12899: value too large for column "SYSMAN"."MGMT_ARU_PRODUCT
Any one got any Ideas
Cheers
Darren
ASKER
dvz
Thanks for replying just to add NLS_LENGTH_SEMANTICS doesnt apply to sys or system isnt the repository part of this.
Thanks for replying just to add NLS_LENGTH_SEMANTICS doesnt apply to sys or system isnt the repository part of this.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
schwertner
Thanks for the input I increased the column and it is working
Cheers
Thanks for the input I increased the column and it is working
Cheers
This error is most probably related to your NLS_CHARACTERSET,
US7ASCI is single-byte, AL32UTF8 is multi-byte (up to 4 byte per character).
You can try with NLS_LENGTH_SEMANTICS=CHAR (default is BYTE),
this parameter applies only to newly created tables, so if you are trying to import data into existing tables, then recreate them first with parameter above and rerun your import.