ORA-00904: : invalid identifier

sql oracle oracle10g ora-00904
itsaboutcode picture itsaboutcode · Dec 15, 2010 · Viewed 11.3k times · Source

I am trying to create a Table in Oracle and getting the error : ORA-00904: : invalid identifier

Here is my command. I really can't see any problem in it. Please help me to identify the error. Thanks.

CREATE TABLE Sale (
CustomerId INT NOT NULL ,
BarCode INT NOT NULL ,
SalesId INT NOT NULL ,
Date DATE NULL ,
CheckOut TINYINT(1) NULL ,
PRIMARY KEY (CustomerId, BarCode, SalesId) ,
CONSTRAINT fk_Customer_has_Product_Customer
FOREIGN KEY (CustomerId )
REFERENCES Customer (CustomerId )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT fk_Customer_has_Product_Product1
FOREIGN KEY (BarCode )
REFERENCES Product (BarCode )
ON DELETE NO ACTION
ON UPDATE NO ACTION);

Answer

Tony Andrews picture Tony Andrews · Dec 15, 2010

The maximum length for an Oracle identifier is 30 characters. These exceed that, are 32 chars long:

  • fk_Customer_has_Product_Customer
  • fk_Customer_has_Product_Product1

See Schema Object Naming Rules

Related questions

How to use BOOLEAN type in SELECT statement

I have a PL/SQL function with BOOLEAN in parameter: function get_something(name in varchar2, ignore_notfound in boolean); This function is a part of 3rd party tool, I cannot change this. I would like to use this function …

Read More
Using 'case expression column' in where clause

SELECT ename , job , CASE deptno WHEN 10 THEN 'ACCOUNTS' WHEN 20 THEN 'SALES' ELSE 'UNKNOWN' END AS department FROM emp /* !!! */ WHERE department = 'SALES' This fails: ORA-00904: "%s: invalid identifier" Is there a way to overcome this limitation in Oracle 10.2 SQL ? How to …

Read More
CASE .. WHEN expression in Oracle SQL

I have the table with 1 column and has following data Status a1 i t a2 a3 I want to display the following result in my select query Status| STATUSTEXT a1 | Active i | Inactive t | Terminated a2 | Active a3 | Active One …

Read More