Re: 11.2.0.3 drop materialized view weirdness

From: <Sarabjit_Toor_at_cooperators.ca>
Date: Thu, 13 Oct 2011 13:26:20 -0400
Message-ID: <OF3CFAC576.9D830779-ON85257928.005F8C7D-85257928.005FBC52_at_cgic.cooperators.ca>

DQo8YnI+PGZvbnQgc2l6ZT0yIGZhY2U9InNhbnMtc2VyaWYiPlRoZSB0YWJsZSwgc2FtZSBuYW1lI GFzIG1hdGVyaWFsaXplZA0Kdmlldywga2VlcGluZyAmbmJzcDt0aGUgZGF0YSBmb3IgJm5ic3A7 dGhlIG1hdGVyaWFsaXplZCB2aWV3IGhhcyBiZWVuIGRyb3BwZWQuPC9mb250Pg0KPGJyPg0KPGJy Pjxmb250IHNpemU9MiBmYWNlPSJzYW5zLXNlcmlmIj5TYXJhYmppdCBUb29yPC9mb250Pg0KPGJy Pg0KPGJyPg0KPGJyPg0KPHRhYmxlIHdpZHRoPTEwMCU+DQo8dHIgdmFsaWduPXRvcD4NCjx0ZD48 Zm9udCBzaXplPTEgY29sb3I9IzVmNWY1ZiBmYWNlPSJzYW5zLXNlcmlmIj5Gcm9tOjwvZm9udD4N Cjx0ZD48Zm9udCBzaXplPTEgZmFjZT0ic2Fucy1zZXJpZiI+VG9vbiBLb3BwZWxhYXJzICZsdDt0 b29uLmtvcHBlbGFhcnNAcnVsZWdlbi5jb20mZ3Q7PC9mb250Pg0KPHRyIHZhbGlnbj10b3A+DQo8 dGQ+PGZvbnQgc2l6ZT0xIGNvbG9yPSM1ZjVmNWYgZmFjZT0ic2Fucy1zZXJpZiI+VG86PC9mb250 Pg0KPHRkPjxmb250IHNpemU9MSBmYWNlPSJzYW5zLXNlcmlmIj5DaHJpcy5TdGVwaGVuc0BhZG0u Y29tPC9mb250Pg0KPHRyPg0KPHRkIHZhbGlnbj10b3A+PGZvbnQgc2l6ZT0xIGNvbG9yPSM1ZjVm NWYgZmFjZT0ic2Fucy1zZXJpZiI+Q2M6PC9mb250Pg0KPHRkPjxmb250IHNpemU9MSBmYWNlPSJz YW5zLXNlcmlmIj4mcXVvdDsnb3JhY2xlLWxAZnJlZWxpc3RzLm9yZycgKG9yYWNsZS1sQGZyZWVs aXN0cy5vcmcpJnF1b3Q7DQombHQ7b3JhY2xlLWxAZnJlZWxpc3RzLm9yZyZndDs8L2ZvbnQ+DQo8 dHIgdmFsaWduPXRvcD4NCjx0ZD48Zm9udCBzaXplPTEgY29sb3I9IzVmNWY1ZiBmYWNlPSJzYW5z LXNlcmlmIj5EYXRlOjwvZm9udD4NCjx0ZD48Zm9udCBzaXplPTEgZmFjZT0ic2Fucy1zZXJpZiI+ MTMvMTAvMjAxMSAxMjozNSBQTTwvZm9udD4NCjx0ciB2YWxpZ249dG9wPg0KPHRkPjxmb250IHNp emU9MSBjb2xvcj0jNWY1ZjVmIGZhY2U9InNhbnMtc2VyaWYiPlN1YmplY3Q6PC9mb250Pg0KPHRk Pjxmb250IHNpemU9MSBmYWNlPSJzYW5zLXNlcmlmIj5SZTogMTEuMi4wLjMgZHJvcCBtYXRlcmlh bGl6ZWQgdmlldw0Kd2VpcmRuZXNzPC9mb250Pg0KPHRyIHZhbGlnbj10b3A+DQo8dGQ+PGZvbnQg c2l6ZT0xIGNvbG9yPSM1ZjVmNWYgZmFjZT0ic2Fucy1zZXJpZiI+U2VudCBieTo8L2ZvbnQ+DQo8 dGQ+PGZvbnQgc2l6ZT0xIGZhY2U9InNhbnMtc2VyaWYiPm9yYWNsZS1sLWJvdW5jZUBmcmVlbGlz dHMub3JnPC9mb250PjwvdGFibGU+DQo8YnI+DQo8aHIgbm9zaGFkZT4NCjxicj4NCjxicj4NCjxi cj48dHQ+PGZvbnQgc2l6ZT0yPkFyZSB5b3UgbG9nZ2VkIGluIGFzIHVzZXIgU1RSQUlOPzxicj4N Ck9uIFRodSwgT2N0IDEzLCAyMDExIGF0IDQ6MjcgUE0sIFN0ZXBoZW5zLCBDaHJpcyAmbHQ7Q2hy aXMuU3RlcGhlbnNAYWRtLmNvbSZndDt3cm90ZTo8YnI+DQo8YnI+DQomZ3Q7IDExLjIuMC4zICZu YnNwO1JIRUwgNTxicj4NCiZndDsgU1FMJmd0OyBkZXNjIG12X3N0cmFpbl94bWw7PGJyPg0KJmd0 OyBFUlJPUjo8YnI+DQomZ3Q7IE9SQS0wNDA0Mzogb2JqZWN0IG12X3N0cmFpbl94bWwgZG9lcyBu b3QgZXhpc3Q8YnI+DQomZ3Q7PGJyPg0KJmd0Ozxicj4NCiZndDsgU1FMJmd0OyBzZWxlY3Qgb3du ZXIsIG9iamVjdF90eXBlIGZyb20gZGJhX29iamVjdHMgd2hlcmUgb2JqZWN0X25hbWUNCj08YnI+ DQomZ3Q7ICdNVl9TVFJBSU5fWE1MJzs8YnI+DQomZ3Q7PGJyPg0KJmd0OyBPV05FUiAmbmJzcDsg Jm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOw0K Jm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7T0JKRUNUX1RZUEU8YnI+DQomZ3Q7IC0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLSAtLS0tLS0tLS0tLS0tLS0tLS0tPGJyPg0KJmd0OyBTVFJB SU4gJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNw OyAmbmJzcDsNCiZuYnNwOyAmbmJzcDsgJm5ic3A7IE1BVEVSSUFMSVpFRCBWSUVXPGJyPg0KJmd0 Ozxicj4NCiZndDsgU1FMJmd0OyBkcm9wIG1hdGVyaWFsaXplZCB2aWV3IG12X3N0cmFpbl94bWw7 PGJyPg0KJmd0Ozxicj4NCiZndDsgTWF0ZXJpYWxpemVkIHZpZXcgZHJvcHBlZC48YnI+DQomZ3Q7 PGJyPg0KJmd0OyBTUUwmZ3Q7IGRlc2MgbXZfc3RyYWluX3htbDs8YnI+DQomZ3Q7IEVSUk9SOjxi cj4NCiZndDsgT1JBLTA0MDQzOiBvYmplY3QgbXZfc3RyYWluX3htbCBkb2VzIG5vdCBleGlzdDxi cj4NCiZndDs8YnI+DQomZ3Q7PGJyPg0KJmd0OyBTUUwmZ3Q7IHNlbGVjdCBvd25lciwgb2JqZWN0 X3R5cGUgZnJvbSBkYmFfb2JqZWN0cyB3aGVyZSBvYmplY3RfbmFtZQ0KPTxicj4NCiZndDsgJ01W X1NUUkFJTl9YTUwnOzxicj4NCiZndDs8YnI+DQomZ3Q7IE9XTkVSICZuYnNwOyAmbmJzcDsgJm5i c3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7DQombmJzcDsgJm5i c3A7ICZuYnNwOyAmbmJzcDtPQkpFQ1RfVFlQRTxicj4NCiZndDsgLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tIC0tLS0tLS0tLS0tLS0tLS0tLS08YnI+DQomZ3Q7IFNUUkFJTiAmbmJzcDsg Jm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOw0K Jm5ic3A7ICZuYnNwOyAmbmJzcDsgTUFURVJJQUxJWkVEIFZJRVc8YnI+DQomZ3Q7PGJyPg0KJmd0 OyBTUUwmZ3Q7PGJyPg0KJmd0Ozxicj4NCiZndDsgQW55IGlkZWFzPzxicj4NCiZndDs8YnI+DQom Z3Q7IENPTkZJREVOVElBTElUWSBOT1RJQ0U6PGJyPg0KJmd0OyBUaGlzIG1lc3NhZ2UgaXMgaW50 ZW5kZWQgZm9yIHRoZSB1c2Ugb2YgdGhlIGluZGl2aWR1YWwgb3IgZW50aXR5IHRvDQp3aGljaDxi cj4NCiZndDsgaXQgaXMgYWRkcmVzc2VkIGFuZCBtYXkgY29udGFpbiBpbmZvcm1hdGlvbiB0aGF0 IGlzIHByaXZpbGVnZWQsIGNvbmZpZGVudGlhbDxicj4NCiZndDsgYW5kIGV4ZW1wdCBmcm9tIGRp c2Nsb3N1cmUgdW5kZXIgYXBwbGljYWJsZSBsYXcuIElmIHRoZSByZWFkZXIgb2YNCnRoaXM8YnI+ DQomZ3Q7IG1lc3NhZ2UgaXMgbm90IHRoZSBpbnRlbmRlZCByZWNpcGllbnQgb3IgdGhlIGVtcGxv eWVlIG9yIGFnZW50IHJlc3BvbnNpYmxlPGJyPg0KJmd0OyBmb3IgZGVsaXZlcmluZyB0aGlzIG1l c3NhZ2UgdG8gdGhlIGludGVuZGVkIHJlY2lwaWVudCwgeW91IGFyZSBoZXJlYnk8YnI+DQomZ3Q7 IG5vdGlmaWVkIHRoYXQgYW55IGRpc3NlbWluYXRpb24sIGRpc3RyaWJ1dGlvbiBvciBjb3B5aW5n IG9mIHRoaXM8YnI+DQomZ3Q7IGNvbW11bmljYXRpb24gaXMgc3RyaWN0bHkgcHJvaGliaXRlZC4g SWYgeW91IGhhdmUgcmVjZWl2ZWQgdGhpczxicj4NCiZndDsgY29tbXVuaWNhdGlvbiBpbiBlcnJv

ciwgcGxlYXNlIG5vdGlmeSB1cyBpbW1lZGlhdGVseSBieSBlbWFpbCByZXBseS48YnI+DQomZ3Q7
PGJyPg0KJmd0Ozxicj4NCiZndDs8YnI+DQomZ3Q7IC0tPGJyPg0KJmd0OyA8L2ZvbnQ+PC90dD48
YSBocmVmPSJodHRwOi8vd3d3LmZyZWVsaXN0cy5vcmcvd2VicGFnZS9vcmFjbGUtbCI+PHR0Pjxm

b250IHNpemU9Mj5odHRwOi8vd3d3LmZyZWVsaXN0cy5vcmcvd2VicGFnZS9vcmFjbGUtbDwvZm9u dD48L3R0PjwvYT48dHQ+PGZvbnQgc2l6ZT0yPjxicj4NCiZndDs8YnI+DQomZ3Q7PGJyPg0KJmd0 Ozxicj4NCjxicj4NCjxicj4NCi0tIDxicj4NClRvb24gS29wcGVsYWFyczxicj4NClJ1bGVHZW4g QlY8YnI+DQpUb29uLktvcHBlbGFhcnNAUnVsZUdlbi5jb208YnI+DQo8L2ZvbnQ+PC90dD48YSBo cmVmPXd3dy5SdWxlR2VuLmNvbT48dHQ+PGZvbnQgc2l6ZT0yPnd3dy5SdWxlR2VuLmNvbTwvZm9u dD48L3R0PjwvYT48dHQ+PGZvbnQgc2l6ZT0yPjxicj4NClRoZUhlbHNpbmtpRGVjbGFyYXRpb24u YmxvZ3Nwb3QuY29tPGJyPg0KPGJyPg0KKGNvKUF1dGhvcjogJnF1b3Q7QXBwbGllZCBNYXRoZW1h dGljcyBmb3IgRGF0YWJhc2UgUHJvZmVzc2lvbmFscyZxdW90Ozxicj4NCjwvZm9udD48L3R0Pjxh IGhyZWY9Ind3dy5ydWxlZ2VuLmNvbS9hbTRkcC1iYWNrY292ZXItdGV4dCI+PHR0Pjxmb250IHNp emU9Mj53d3cucnVsZWdlbi5jb20vYW00ZHAtYmFja2NvdmVyLXRleHQ8L2ZvbnQ+PC90dD48L2E+ PHR0Pjxmb250IHNpemU9Mj48YnI+DQo8YnI+DQo8YnI+DQotLTxicj4NCjwvZm9udD48L3R0Pjxh IGhyZWY9Imh0dHA6Ly93d3cuZnJlZWxpc3RzLm9yZy93ZWJwYWdlL29yYWNsZS1sIj48dHQ+PGZv bnQgc2l6ZT0yPmh0dHA6Ly93d3cuZnJlZWxpc3RzLm9yZy93ZWJwYWdlL29yYWNsZS1sPC9mb250 PjwvdHQ+PC9hPjx0dD48Zm9udCBzaXplPTI+PGJyPg0KPGJyPg0KPGJyPg0KPC9mb250PjwvdHQ+ DQo8YnI+DQo8YnI+PGZvbnQgc2l6ZT0yIGZhY2U9InNhbnMtc2VyaWYiPjxicj4NCjwvZm9udD4N Cjxicj4NCjxicj48Zm9udCBzaXplPTEgY29sb3I9IzgwODA4MCBmYWNlPSJzYW5zLXNlcmlmIj48 YnI+DQo8YnI+DQpQbGVhc2UgY29uc2lkZXIgdGhlIGVudmlyb25tZW50IGJlZm9yZSBwcmludGlu ZyB0aGlzIGVtYWlsPGJyPg0KPGJyPg0KVGhpcyBtZXNzYWdlLCBpbmNsdWRpbmcgYW55IGF0dGFj aGVkIGRvY3VtZW50cywgaXMgaW50ZW5kZWQgZm9yIHRoZSBhZGRyZXNzZWVzDQpvbmx5LiBJdCBt YXkgY29udGFpbiBpbmZvcm1hdGlvbiB0aGF0IGlzIGNvbmZpZGVudGlhbCwgcHJpdmlsZWdlZCBh bmQvb3INCmV4ZW1wdCBmcm9tIGRpc2Nsb3N1cmUuIE5vIHJpZ2h0cyB0byBwcml2aWxlZ2Ugb3Ig Y29uZmlkZW50aWFsaXR5IGhhdmUNCmJlZW4gd2FpdmVkLiBBbnkgdW5hdXRob3JpemVkIHVzZSBv ciBkaXNjbG9zdXJlIGlzIHByb2hpYml0ZWQuIElmIHlvdSBoYXZlDQpyZWNlaXZlZCB0aGlzIG1l c3NhZ2UgaW4gZXJyb3IsIHBsZWFzZSByZXBseSB0byB0aGUgc2VuZGVyIGJ5IGUtbWFpbCBhbmQN CmRlbGV0ZSBvciBkZXN0cm95IGFsbCBjb3BpZXMgb2YgdGhpcyBtZXNzYWdlLjxicj4NCjxicj4N CkF2YW50IGQnaW1wcmltZXIgY2UgY291cnJpZWwsIHBlbnNleiDDoCBsJ2Vudmlyb25uZW1lbnQ8 YnI+DQo8YnI+DQpDZSBtZXNzYWdlLCBpbmNsdWFudCB0b3VzIGxlcyBkb2N1bWVudHMgam9pbnRz LCBlc3Qgw6AgbCdpbnRlbnRpb24gZGVzIGRlc3RpbmF0YWlyZXMNCnZpc8OpcyBzZXVsZW1lbnQu Jm5ic3A7IElsIHBldXQgY29udGVuaXIgZGVzIHJlbnNlaWduZW1lbnRzIGNvbmZpZGVudGllbHMs DQpwcm90w6lnw6lzIGV0L291IG5lIHBvdXZhbnQgcGFzIMOqdHJlIGRpdnVsZ3XDqXMuJm5ic3A7 Jm5ic3A7IEF1Y3VuZSByZW5vbmNpYXRpb24NCm4nZXN0IGZhaXRlIHF1YW50IMOgIHNhIG5hdHVy ZSBjb25maWRlbnRpZWxsZSBldCBwcml2aWzDqWdpw6llLiZuYnNwOyBQYXINCmNvbnPDqXF1ZW50 LCB0b3V0ZSBkaWZmdXNpb24gb3UgdXRpbGlzYXRpb24gbm9uIGF1dG9yaXPDqWUgZXN0IHN0cmlj dGVtZW50DQppbnRlcmRpdGUuJm5ic3A7IFNpIHZvdXMgYXZleiByZcOndSBjZSBtZXNzYWdlIHBh ciBlcnJldXIsIHZldWlsbGV6IGVuIGF2aXNlcg0KaW1tw6lkaWF0ZW1lbnQgbOKAmWV4cMOpZGl0 ZXVyIHBhciByZXRvdXIgZGUgY291cnJpZWwgZXQgZW4gZMOpdHJ1aXJlIHRvdXRlcw0KbGVzIGNv cGllcyBleGlzdGFudGVzLjxicj4NCjwvZm9udD4NCjxicj48Zm9udCBzaXplPTEgY29sb3I9Izgw ODA4MD48YnI+DQo8YnI+DQo8L2ZvbnQ+DQo8YnI+DQo=

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

Received on Thu Oct 13 2011 - 12:26:20 CDT