Author: Dev

ORA-00922: missing or invalid option Oracle PL/SQL error message: ORA-00922: missing or invalid option. Cause: An invalid option was specified in defining a column or storage clause. Solution: Correct the syntax. Example: CREATE TABLE TEST4 SELECT * FROM TEST3; Output: ORA-00922: missing or invalid option Correct: CREATE TABLE TEST4 AS SELECT * FROM TEST3; Output:…(Continue Reading)

ORA-00972: identifier is too long Oracle PL/SQL error message: ORA-00972: identifier is too long. Cause: You try to create an object name with more than 30 characters was specified. Solution: Specify at most 30 characters for the object name. Example: CREATE OR REPLACE VIEW AAAAA_BBBBB_CCCCC_DDDDD_12345678 AS SELECT * FROM TEST3; Output: ORA-00972: identifier is too…(Continue Reading)

ORA-02296: cannot enable – null values found Oracle PL/SQL error message: ORA-02296: cannot enable – null values found. Cause: You execute an ALTER TABLE statement with an ENABLE CONSTRAINT clause failed because the table contains NULL values. Solution: Set all NULL values in the column to values other than NULL, then re-execute the statement. Example:…(Continue Reading)

ORA-01449: column contains NULL values; cannot alter to NOT NULL Oracle PL/SQL error message: ORA-01449: column contains NULL values; cannot alter to NOT NULL. Cause: You execute an ALTER TABLE MODIFY statement attempted to change the definition of a column containing NULL values to NOT NULL. Solution: Set all NULL values in the column to…(Continue Reading)

ORA-01430: column being added already exists in table Oracle PL/SQL error message: ORA-01430: column being added already exists in table. Cause: You execute an ALTER TABLE ADD statement with a column that is already in the table. All column names must be unique within a table. Solution: Change the column name to be unique, then…(Continue Reading)