ORA-12899: value too large for column | Karan Rajpoot

ORA-12899: value too large for column

In this article you will get to know how we can resolve ORA-12899: value too large for column issue.

Error: – ORA-12899: value too large for column.

Cause: – This error occurs when you have given the data type value which is greater than its maximum value.

Solution: – Try to give the data type value under its maximum assign value or try to increase the size of the maximum value.

let’s understand the things with the help of the below example: –

Example: –


Step 1)

SQL> create table employee (emp_id number, emp_name varchar(10), emp_desig varchar(10));

Table created.


Step 2)
SQL> insert into employee values (1001, ‘Paul’, ‘Project_Engineer’);
insert into employee values (1001, ‘Paul’, ‘Project_Engineer’)
                                           *
ERROR at line 1:
ORA-12899: value too large for column “SYS”.”EMPLOYEE”.”EMP_DESIG” (actual: 16,
maximum: 10)
Note: – At the time of table creation the data type value of the emp_desig has given as 10 but the value of  emp_design which has been inserted it was greater than its data type value, this is the cause that error has occurred.
Advertisement

Hope this blog will help you!!

If this article is useful for you please comment, share with your friends.

In case of any issues please send your query to below comment section.

For more articles please do visit below links: –

ORA-01119: error in creating database file | Karan Rajpoot

ORA-02140: invalid tablespace name | Karan Rajpoot

How to resolve “TNS-12547: TNS:lost contact TNS-12560: TNS:protocol adapter error TNS-00517: Lost contact” | Karan Rajpoot

How to resolve “TNS-12541 : TNS : no listener” error

If you want to download Oracle virtual box or VMware Workstation Player, Please click on below links:-

Oracle Virtual Box

VMware Workstation Player

Advertisement

This Post Has 2 Comments

Leave a Reply