Re: Materialized Views
From: frank <frank.van.bortel_at_gmail.com>
Date: Sun, 18 Apr 2010 11:20:06 +0200
Message-ID: <13578$4bcacec7$524ba3af$31342_at_cache4.tilbu1.nb.home.nl>
Shakespeare wrote:
Date: Sun, 18 Apr 2010 11:20:06 +0200
Message-ID: <13578$4bcacec7$524ba3af$31342_at_cache4.tilbu1.nb.home.nl>
Shakespeare wrote:
>
> Just got this from metalink: sometimes when the MV is dropped, the
> MV-table with the same name still exists (a MV has a table with the same
> name). It's a bug.
> Metalink note 565532.1
>
> Shakespeare
Wouldn't that be while using "create MV on prebuilt table as select ..."? Not if you just did "create MV as select".
OP: would there perhaps be a state in time, where a prebuilt table existed? Or a synonym with the same name?
Regards,
frank van bortel
Received on Sun Apr 18 2010 - 04:20:06 CDT