dropping materialized view

From: Jeroen van Sluisdam <jeroen.van.sluisdam_at_vrijuit.nl>
Date: Tue, 09 Dec 2003 07:59:29 -0800
Message-ID: <F001.005D94EF.20031209075929@fatcity.com>

Hi,

I have a serious problem in dropping a snapshot/mview

I cannot find whatever constraint is blocking this.

Any advice is appreciated

SQL> drop snapshot deca.mediums;

drop snapshot deca.mediums

ERROR at line 1:

ORA-02449: unique/primary keys in table referenced by foreign keys

SQL> drop materialized view deca.mediums;

drop materialized view deca.mediums

ERROR at line 1:

ORA-02449: unique/primary keys in table referenced by foreign keys

SQL> SELECT * FROM dba_constraints where table_name = 'MEDIUMS';

no rows selected

I get the samen results when dropping as owner and as sys

Details: Oracle 9.2.0.4 HP-UX11.11

Tnx,

Jeroen

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jeroen van Sluisdam
  INET: jeroen.van.sluisdam_at_vrijuit.nl

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Dec 09 2003 - 09:59:29 CST