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