There is a note on Metalink about this problem
I ran into it before
Lookup note 265455.1 on Metalink
--
Syltrem
OpenVMS 7.3-1 + Oracle 8.1.7.4
http://pages.infinit.net/syltrem (OpenVMS related web site, en français)
---zulu is not in my email address---
"chris b" <chris.brown_at_providenthims.co.uk> a écrit dans le message de
news:1119344437.781982.69880_at_g44g2000cwa.googlegroups.com...
> I am trying to drop a table but can't because it says I have to drop a
> materialized view which doesn't exist ...I found this out when I tried
> to follow the suggestion below!
>
> ORA-12083: must use DROP MATERIALIZED VIEW to drop
> "LIVEDW"."MV_NBVBROKER"
>
>
> Any ideas on how I can get round this ...I seem to have inconsistency
> between a materialized view & a table
>
> Thanks in advance
>
Received on Thu Jun 23 2005 - 13:46:16 CDT
