简单的SQL没有被执行？
CREATE TABLE QRes
(
"QUERY_ID" VARCHAR2(32) NOT NULL,
PRIMARY KEY ("QR_ID"),
"SOURCE" VARCHAR2(255),
CONSTRAINT "FHDHDHJS89" FOREIGN KEY ("QrES_ID")
REFERENCES "DQM_QUERY" ("Q_ID") ENABLE
) TABLESPACE "USERS"
LOB ("DATA") STORE AS (
TABLESPACE "USERS" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10
NOCACHE LOGGING);
我得到的输出是ORA-00942：表或视图不存在
我的SQL语法错误吗？
CREATE TABLE QRes
(
"QUERY_ID" VARCHAR2(32) NOT NULL,
PRIMARY KEY ("QR_ID"),
"SOURCE" VARCHAR2(255),
CONSTRAINT "FHDHDHJS89" FOREIGN KEY ("QrES_ID")
REFERENCES "DQM_QUERY" ("Q_ID") ENABLE
) TABLESPACE "USERS"
LOB ("DATA") STORE AS (
TABLESPACE "USERS" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10
NOCACHE LOGGING);
The output I am getting is ORA-00942: table or view does not exist
Is my SQL syntax wrong?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
这是一个运行时错误。语法很好并且您的语句被执行，但随后遇到了问题。在这种情况下，问题在于某些引用的表不存在。看语句，只能是
DQM_QUERY。它存在吗？This is a runtime error. The syntax is fine and your statement is executed, but then it runs into a problem. The problem being in this case, that some referenced table does not exist. Looking at the statement, that can only be
DQM_QUERY. Does it exist?