Posts

Showing posts with the label ORA-ERROR

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

                                              ORA-12899: value too large for column 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 tabl

ORA-00984: column not allowed here - Karan Rajpoot

                                                  ORA-00984: column not allowed here Error: -  ORA-00984: column not allowed here. Cause: - When you try to insert the value in a table and forget to enclose the string value in a single quote, then you will get this error. Solution: - Put the string value under single quotes and re-execute the command again. Example: -  SQL> insert into employee values (1001, Paul, Engineer); insert into employee values (1001, Paul, Engineer)                                          * ERROR at line 1: ORA-00984: column not allowed here Note: - In the above output string value has not enclosed with single quotes, To resolve this, Put the string value under single quotes and re-run the command again like below. SQL> insert into employee values (1001, 'Paul', 'Engineer'); 1 row created. Hope that will resolve your issue.

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

                                      ORA-01119: error in creating database file Error: -  ORA-01119: error in creating a database file Cause: - Datafile size has not mentioned in the datafile creation command. Solution: - Mention the datafile size at the end of the command and re-execute it.  Example: - SQL> alter tablespace users add datafile '/u01/app/oracle/oradata/prod/users02.dbf'; alter tablespace users add datafile '/u01/app/oracle/oradata/prod/users02.dbf' * ERROR at line 1: ORA-01119: error in creating database file '/u01/app/oracle/oradata/prod/users02.dbf' ORA-17610: file '/u01/app/oracle/oradata/prod/users02.dbf' does not exist and no size specified ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Note: - In the above command datafile size has not mentioned at the end of the command, Put the datafile size and re-execute co

ORA-02140: invalid tablespace name | Karan Rajpoot

                                                     ORA-02140: invalid tablespace name Error: -  ORA-02140: invalid tablespace name  Cause: - Tablespace name has not provided correctly while running the alter command Solution: - Use the correct tablespace name and again retry to execute alter command Command to check the tablespaces name: - select name from v$tablespace; Example: - SQL> alter tablespace user add datafile '/u01/app/oracle/oradata/prod/user02.dbf' ; alter tablespace user add datafile '/u01/app/oracle/oradata/prod/user02.dbf'                  * ERROR at line 1: ORA-02140: invalid tablespace name Note: - In the above command, tablespace name provided incorrectly, Correct tablespace name was  USERS. Now again rerun the command using correct tablespace name. Hope that will resolve your issue.