Create View in MS Query on Oracle data

[Anon]

When I issue a create view statement in MS Query and try to execute it against the oracle database I get an error messaging stating the view does not exist. I haven't tried to create a view using MS Query before but I assume the create view statement is the same as if I where in oracle. Any idea why I get the error message.

[ccranium]

MS SQL has some commands that are not standard ANSI SQL and therefore won't be known by other SQL interpreters.

Is there a "drop view" command in your create view query anywhere? auto-generated MS SQL will often check for and drop an existing object before creating a new one, maybe the check got deleted but the drop stayed.