Re: 11.2.0.3 drop materialized view weirdness

From: Toon Koppelaars <toon.koppelaars_at_rulegen.com>
Date: Thu, 13 Oct 2011 18:34:10 +0200
Message-ID: <CAA9w=EuzRWb8OetDX9SR7Gv_o+T=2LKee71xNFDucVa4rOob-g_at_mail.gmail.com>

Are you logged in as user STRAIN?
On Thu, Oct 13, 2011 at 4:27 PM, Stephens, Chris <Chris.Stephens_at_adm.com>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.
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Toon Koppelaars
RuleGen BV
Toon.Koppelaars_at_RuleGen.com
www.RuleGen.com
TheHelsinkiDeclaration.blogspot.com

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


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

Received on Thu Oct 13 2011 - 11:34:10 CDT