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