Invalid column name problem

From: Jordan <warlord_at_netvigator.com>
Date: Sun, 16 Sep 2001 15:02:33 +0800
Message-ID: <9o1ih4$sci5@imsp212.netvigator.com>

Dear all,

                During I used sqlplus / svrmgrl, when I refer some table

column, oracle always said that "invalid column name", e.g. a table "dept" has the following structure

Column Name                    Null?    Type
------------------------------ -------- ----
DEPTNO                         NOT NULL NUMBER(38)
DNAME                          NOT NULL CHAR(30)
LOC                                     CHAR(30)

When I type "alter table dept add constraint chk_loc (LOC NOT NULL)", the error message "ORA-00904: invalid column name" appears. I have tried using different case and the problem still exists. Can anyone help me?

Best Regards,
Jordan Received on Sun Sep 16 2001 - 02:02:33 CDT