• VMware

    Learn about VMware virtualization for its products like vsphere ESX and ESXi, vCenter Server, VMware View, VMware P2V and many more

  • Linux

    Step by step configuration tutorials for many of the Linux services like DNS, DHCP, FTP, Samba4 etc including many tips and tricks in Red Hat Linux.

  • Database

    Learn installation and configuration of databases like Oracle, My SQL, Postgresql, etc including many other related tutorials in Linux.

  • How to Fix ORA-12899: value too large

    The other day I was installing Peopletools on a Linux instance when I came across this error and I am sure some body else also might get stuck at this stage so i would like to post the solution for this error.

    Error:
    SQL Error. Error position: 129 Return: 12899 - ORA-12899: value too large for column "SYSADM". "PS_CAN_GOV_COUNTRY". "DESCR" (actual: 33, maximum: 30)
    Error: Unable to insert row 280
    Error: SQL execute error for CAN_GOV_COUNTRY
    Unsuccessful Completition
    Solution:
    Increase the destination column manually as required to insert the rows in that column.
    sql>desc PS_CAN_GOV_COUNTRY;
    Name                                      Null?    Type
    ----------------------------------------- -------- ----------------------------
    CAN_COUNTRY_CD                            NOT NULL VARCHAR2(5 CHAR)
    EFFDT                                     NOT NULL DATE
    EFF_STATUS                                NOT NULL VARCHAR2(1 CHAR)
    DESCR                                     NOT NULL VARCHAR2(30 CHAR)
    DESCRSHORT                                NOT NULL VARCHAR2(10 CHAR)
    
    sql> alter table PS_CAN_GOV_SCHOOL modify DESCR VARCHAR2(35);
    Table altered.
    
    sql> commit;
    Commit complete.

    Follow the below links for more tutorials
    Deepak Prasad

    Deepak Prasad is an anonymous techie and an author who is still trying to survive in this IT generation with very little knowledge he has on Linux/Unix, VMware, SAN Storage, Automation, networking etc

    You can follow him on Facebook or Google+

    Do you also have something to share here?

    Become an author and be a part of our GoLinuxHub Team, Click here for more information
    How to Fix ORA-12899: value too large How to Fix ORA-12899: value too large Reviewed by Deepak Prasad on Monday, October 08, 2012 Rating: 5

    No comments:

    Powered by Blogger.