dropping materialized view

2003-12-09 Thread Jeroen van Sluisdam
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

Re: dropping materialized view

2003-12-09 Thread Mohammed Shakir
Please try this select table_name, constraint_name from all_constraints where r_constraint_name in ( select constraint_name from all_constraints where table_name = 'MEDIUMS') it should give you the table_name constraint names that are not allowing you to drop your table. You will have to

RE: dropping materialized view

2003-12-09 Thread Jeroen van Sluisdam
corrupted the dictionary. I hope you can shed some light on this Regards, Jeroen Van: Mohammed Shakir [mailto:[EMAIL PROTECTED] Verzonden: dinsdag 9 december 2003 17:59 Aan: Multiple recipients of list ORACLE-L Onderwerp: Re: dropping materialized view Please try this select table_name

RE: dropping materialized view

2003-12-09 Thread Igor Neyman
Onderwerp: Re: dropping materialized view Please try this select table_name, constraint_name from all_constraints where r_constraint_name in ( select constraint_name from all_constraints where table_name = 'MEDIUMS') it should give you the table_name constraint names that are not allowing you to drop

RE: dropping materialized view

2003-12-09 Thread Jeroen van Sluisdam
Oops I feel very stupid, thanks a lot Igor this did the tric. Regards Jeroen -Oorspronkelijk bericht- Van: Igor Neyman [mailto:[EMAIL PROTECTED] Verzonden: dinsdag 9 december 2003 21:09 Aan: Multiple recipients of list ORACLE-L Onderwerp: RE: dropping materialized view Disabling

RE: dropping materialized view

2003-12-09 Thread Igor Neyman
Jeroen -Oorspronkelijk bericht- Van: Igor Neyman [mailto:[EMAIL PROTECTED] Verzonden: dinsdag 9 december 2003 21:09 Aan: Multiple recipients of list ORACLE-L Onderwerp: RE: dropping materialized view Disabling constraint (when you want to drop the parent table) will not help. This should

RE: Problem in dropping Materialized View

2003-10-17 Thread Hitchman, Peter
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.

RE: Problem in dropping Materialized View

2003-10-17 Thread Siddharth Haldankar
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

RE: Problem in dropping Materialized View

2003-10-17 Thread babette.turnerunderwood
: Problem in dropping Materialized View Hi Gurus Oracle 8.1.7 on HP Unix I have some problems in Materialized view Here are the sequence of steps Created a normal view CT_PRODUCTID_VW Created a materialized view CT_PRODUCID_MVW Dropped view

Problem in dropping Materialized View

2003-10-16 Thread Siddharth Haldankar
Hi Gurus Oracle 8.1.7 on HP Unix I have some problems in Materialized view Here are the sequence of steps Created a normal view CT_PRODUCTID_VW Created a materialized view CT_PRODUCID_MVW Dropped view CT_PRODUCTID_VW Rename CT_PRODUCTID_MVW to