Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> CREATE/DROP ANY VIEW question
Hi,
Using a schema that has CREATE/DROP ANY VIEW privileges, I can CREATE a view in another schema, I can DROP that view, but I cannot CREATE OR REPLACE the view, either creating or replacing the view.
Am I doing something wrong, or is that an Oracle quirk? There's an obvious workaround (DROP, trap the exception, then CREATE), but that lacks beauty.
Thanks for any help,
Steve Received on Wed Apr 14 1999 - 07:36:41 CDT