ORA-00942：表或视图不存在 [英] ORA-00942: table or view does not exist

问题描述

当我创建一个表，然后跟随错误进入我的代码中任何一个请帮助我，



错误是

ORA-00942：桌子或视图不存在



我的代码是

hi when i am creating a table then following error come in my code any one please help me,,

the error is
ORA-00942: table or view does not exist

and my code is

if (i == 0)
                            {
                                cmd.CommandText = "CREATE TABLE BIOAS_2ES.OFF_MST(CMP_CD VARCHAR2(10 BYTE) NOT NULL ENABLE,ULOGIN_ID VARCHAR2(20 BYTE) NOT NULL ENABLE,OFF_CD VARCHAR2(20 BYTE) NOT NULL ENABLE,OFF_NAME VARCHAR2(50 BYTE) NOT NULL ENABLE,OFF_TYPE VARCHAR2(10 BYTE) NOT NULL ENABLE,CTL_CD VARCHAR2(20 BYTE) NOT NULL ENABLE,OFF_ADD VARCHAR2(150 BYTE),EMAIL_ID VARCHAR2(50 BYTE) NOT NULL ENABLE,PHONE_NO1 VARCHAR2(15 BYTE),PHONE_NO2 VARCHAR2(15 BYTE),FAX_NO VARCHAR2(15 BYTE),DISABLE VARCHAR2(1 BYTE) DEFAULT 'F' NOT NULL ENABLE,CONTACT_PER_ID1 VARCHAR2(20 BYTE),CONTACT_PER_ID2 VARCHAR2(20 BYTE),SYS_DATE TIMESTAMP (6) DEFAULT SYSDATE NOT NULL ENABLE,CONSTRAINT OFF_MST_PK PRIMARY KEY (CMP_CD, OFF_CD) USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE USERS ENABLE,CONSTRAINT OFF_MST_UK1 UNIQUE (CMP_CD, OFF_NAME) USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE USERS ENABLE,CONSTRAINT OFF_MST_OFF_TYPES_FK1 FOREIGN KEY (CMP_CD, OFF_TYPE) REFERENCES BIOAS_ES.OFF_TYPES (CMP_CD, OFF_TYPE) ENABLE)PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)TABLESPACE USERS";
                                i = cmd.ExecuteNonQuery();

推荐答案

检查你的FOREIGN KEY定义 - BIOAS_ES .OFF_TYPES 表存在吗？或者应该 BIOAS_2ES.OFF_TYPES 来匹配CREATE TABLE名称？

Check your FOREIGN KEY definition - does the BIOAS_ES.OFF_TYPES table exist? Or should it be BIOAS_2ES.OFF_TYPES to match the CREATE TABLE name?

这篇关于ORA-00942：表或视图不存在的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！