Re: Error While Dropping tbs

Thanks you so much Howard Latham and Ray Stell ... i have tried by the way you have suggested. It worked for me....

Regards,
Nagaraj

On Sat, Nov 1, 2008 at 8:20 PM, Howard Latham <howard.latham_at_gmail.com>wrote:

> you need to drop any indexs related mvs too.
>
> 2008/11/1 Ray Stell <stellr_at_cns.vt.edu>
>
>> On Sat, Nov 01, 2008 at 04:42:44PM +0530, Nagaraj S wrote:
>> >
>> > kindly help me to over come this issue. i have tried to find the MViews
>> in
>> > C_LCFJ_BDACCT_MV tbs and dropped them, still get the same error.
>>
>>
>> you have to locate these mviews and drop them before you can drop the ts:
>>
>> SQL> select MVIEW_NAME, QUERY from DBA_MVIEWS where ...;
>>
>> SQL> DROP MATERIALIZED VIEW ...;
>>
>> Materialized view dropped.
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>
>
> --
> Howard A. Latham
>
>

--
http://www.freelists.org/webpage/oracle-l