Re: Error While Dropping tbs
From: Ray Stell <stellr_at_cns.vt.edu>
Date: Sat, 1 Nov 2008 09:42:16 -0400
Message-ID: <20081101134216.GA16221@cns.vt.edu>
Date: Sat, 1 Nov 2008 09:42:16 -0400
Message-ID: <20081101134216.GA16221@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-lReceived on Sat Nov 01 2008 - 08:42:16 CDT