oracle SQL error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

oracle SQL error

Author

Topic

copelandtml
Starting Member

5 Posts

Posted - 2011-02-02 : 14:15:19

I have a bunch of tables I have in the same query that I am trying to assign primary and foreign keys too.

I get the following answer after running it:
[SQL] DROP TABLE Orders CASCADE CONSTRAINTS
[Err] ORA-00942: table or view does not exist

I have then tried running the orders table by itself and then get this error:
[SQL] DROP TABLE Orders CASCADE CONSTRAINTS
[Err] ORA-00942: table or view does not exist

I can supply all the sql if needed its over a hundred lines though so thought I'd just ask first in case others have come across this before.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-02-02 : 14:20:34

You've posted your question on a Microsoft SQL Server site. Oracle questions are better answered on sites that specialize in Oracle.