Re: 11.2.0.3 drop materialized view weirdness

  • From: Toon Koppelaars <toon.koppelaars@xxxxxxxxxxx>
  • To: Chris.Stephens@xxxxxxx
  • Date: Thu, 13 Oct 2011 18:34:10 +0200

Are you logged in as user STRAIN?
On Thu, Oct 13, 2011 at 4:27 PM, Stephens, Chris <Chris.Stephens@xxxxxxx>wrote:

> 11.2.0.3  RHEL 5
> SQL> desc mv_strain_xml;
> ERROR:
> ORA-04043: object mv_strain_xml does not exist
>
>
> SQL> select owner, object_type from dba_objects where object_name =
> 'MV_STRAIN_XML';
>
> OWNER                          OBJECT_TYPE
> ------------------------------ -------------------
> STRAIN                         MATERIALIZED VIEW
>
> SQL> drop materialized view mv_strain_xml;
>
> Materialized view dropped.
>
> SQL> desc mv_strain_xml;
> ERROR:
> ORA-04043: object mv_strain_xml does not exist
>
>
> SQL> select owner, object_type from dba_objects where object_name =
> 'MV_STRAIN_XML';
>
> OWNER                          OBJECT_TYPE
> ------------------------------ -------------------
> STRAIN                         MATERIALIZED VIEW
>
> SQL>
>
> Any ideas?
>
> CONFIDENTIALITY NOTICE:
> This message is intended for the use of the individual or entity to which
> it is addressed and may contain information that is privileged, confidential
> and exempt from disclosure under applicable law. If the reader of this
> message is not the intended recipient or the employee or agent responsible
> for delivering this message to the intended recipient, you are hereby
> notified that any dissemination, distribution or copying of this
> communication is strictly prohibited. If you have received this
> communication in error, please notify us immediately by email reply.
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>


-- 
Toon Koppelaars
RuleGen BV
Toon.Koppelaars@xxxxxxxxxxx
www.RuleGen.com
TheHelsinkiDeclaration.blogspot.com

(co)Author: "Applied Mathematics for Database Professionals"
www.rulegen.com/am4dp-backcover-text


--
//www.freelists.org/webpage/oracle-l


Other related posts: