Re: Error While Dropping tbs
- From: "Howard Latham" <howard.latham@xxxxxxxxx>
- To: stellr@xxxxxxxxxx
- Date: Sat, 1 Nov 2008 14:50:10 +0000
you need to drop any indexs related mvs too.
2008/11/1 Ray Stell <stellr@xxxxxxxxxx>
> 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
Other related posts: