Re: 11.2.0.3 drop materialized view weirdness
- From: Sarabjit_Toor@xxxxxxxxxxxxxx
- To: toon.koppelaars@xxxxxxxxxxx
- Date: Thu, 13 Oct 2011 13:26:20 -0400
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=
--
//www.freelists.org/webpage/oracle-l
Other related posts:
