Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: DB SQL error
Naga Pappireddi wrote:
> I am executing the following statement:
> ALTER TABLE COMPANY_USER ADD CONSTRAINT COMPANY_U
> SER_FK_2 FOREIGN KEY (USER_ID) REFERENCES MAM_USER (USER_ID)
>
> And I get:
> [sql] Failed to execute: ALTER TABLE COMPANY_USER ADD CONSTRAINT
> COMPANY_U
> SER_FK_2 FOREIGN KEY (USER_ID) REFERENCES MAM_USER (USER_ID)
> [sql] java.sql.SQLException: ORA-00942: table or view does not
> exist
>
> The SQL is auto-generated by TDK(turbine development Kit XML schema
> engine). I am not sure how I can solve this problem. I appreciate your
> help
I would start with the spelling. Do that tables and columns exist that are in the text above? Are they in the same schema? If not do the appropriate grants and synonyms exist?
Daniel Morgan Received on Tue May 07 2002 - 09:57:41 CDT