Re: Materialized Views
From: Shakespeare <whatsin_at_xs4all.nl>
Date: Sun, 18 Apr 2010 12:03:35 +0200
Message-ID: <4bcad8f7$0$22945$e4fe514c_at_news.xs4all.nl>
Op 18-4-2010 11:20, frank schreef:
> 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
Date: Sun, 18 Apr 2010 12:03:35 +0200
Message-ID: <4bcad8f7$0$22945$e4fe514c_at_news.xs4all.nl>
Op 18-4-2010 11:20, frank schreef:
> 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
The note does not mention that. Some references do, though. It states: It is possible that an earlier drop of Mview did not complete successfully. It could be verified by checking dba_objects.
Shakespeare. Received on Sun Apr 18 2010 - 05:03:35 CDT