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
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
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
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
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
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
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.
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
: 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
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
10 matches
Mail list logo