Hi,
Did you rename the materialized view? If so you are probably hitting bug
1335477. Can you see the view name in user_mviews? I think you have to try
and re-create the materialized view and then drop it.
Really suggest you contact Oracle, unless someone on the list has the
definitive fix.
Hitchman
Thanks a ton, Yes it is a bug.
With Warm Regards
_
Siddharth Haldankar
Cisco Systems Inc. ODC
Zensar Technologies Ltd.
# : 4128374
[EMAIL PROTECTED]
[EMAIL PROTECTED]
-Original Message-
Hitchman, Peter
Sent: Friday, October 17, 2003 3:04 PM
To: Multiple
Title: Message
Re-create the materialized view and then try to drop
it.
Because you tried to rename it to the view name, I would say try it both
as the view name and as the original name.
I know
it sounds silly but we had this problem once and creating it , will create
whatever internal