PROBLEMA:

[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”VGh1IE9jdCAxMSAxNjowMjo0NCAyMDEyCkVycm9ycyBpbiBmaWxlIC91MDEvYXBwL29yYWNsZS9hZG1pbi9zZXJ2aWNvcy91ZHVtcC9zZXJ2aWNvczFfb3JhXzI3ODQ1LnRyYzoKT1JBLTAwNjAwOiBpbnRlcm5hbCBlcnJvciBjb2RlLCBhcmd1bWVudHM6IFtrdGZidGdleC03XSwgWzEwMTU4MTddLCBbMTAyNF0sIFsxMDE1ODE2XSwgW10sIFtdLCBbXSwgW10KRGFkb3MgYWRpY2lvbmFpczoKI0RhdGFiYXNlIFVQOgotUmVkSGF0IDUuNiB4ODZfNjQKLU9yYWNsZSAxMC4yLjAuNCA2NGJpdAojQXBsaWNhw6fDo28gVVAg4oCTIG1hcyBhbyBpbnNlcmlyIGVtIHVtYSB0YWJlbGEgbW9zdHJhdmEgbyBPUkEtMDA2MDAgbmEgdGVsYSBwcm8gdXN1w6FyaW8u” hover_enabled=”0″]VGh1IE9jdCAxMSAxNjowMjo0NCAyMDEyCkVycm9ycyBpbiBmaWxlIC91MDEvYXBwL29yYWNsZS9hZG1pbi9zZXJ2aWNvcy91ZHVtcC9zZXJ2aWNvczFfb3JhXzI3ODQ1LnRyYzoKT1JBLTAwNjAwOiBpbnRlcm5hbCBlcnJvciBjb2RlLCBhcmd1bWVudHM6IFtrdGZidGdleC03XSwgWzEwMTU4MTddLCBbMTAyNF0sIFsxMDE1ODE2XSwgW10sIFtdLCBbXSwgW10KRGFkb3MgYWRpY2lvbmFpczoKI0RhdGFiYXNlIFVQOgotUmVkSGF0IDUuNiB4ODZfNjQKLU9yYWNsZSAxMC4yLjAuNCA2NGJpdAojQXBsaWNhw6fDo28gVVAg4oCTIG1hcyBhbyBpbnNlcmlyIGVtIHVtYSB0YWJlbGEgbW9zdHJhdmEgbyBPUkEtMDA2MDAgbmEgdGVsYSBwcm8gdXN1w6FyaW8u[/et_pb_dmb_code_snippet]

SOLUÇÃO:

Segundo a nota ID 178643.1:

“O problema pode ocorrer se o final de um datafile fica no final de um bloco bitmap.
Neste caso, o campo de “primeiro bit livre” pode ficar avançado após o final do arquivo de dados.”
<tradução livre>

Fix: Migrar para 11.x.x.x

Fix é migrar Larry? Tá de sacanagem né? O.o

Workaround que imaginei (não consta na doc e é algo simples… tsc tsc tsc):

1) Criação de nova tablespace para a tabela e outra para os seus indexes;
2) Move da tabela para nova tablespace e rebuild de cada index para a nova tablespace;

[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”MTY6MTQ6MjAgYmFuY28xPiBjcmVhdGUgdGFibGVzcGFjZSBhcGxpY2FjYW9fZGF0YTAxCjE2OjE0OjIwICAgMiBkYXRhZmlsZQoxNjoxNDoyMCAgIDMgJytEQVRBNC9iYW5jby9kYXRhZmlsZS9hcGxpY2FjYW9fZGF0YTAxLmRiZicgc2l6ZSA1MDAwbSBhdXRvZXh0ZW5kIG9uIG5leHQgNTAwbSBtYXhzaXplIDEwMDAwbQoxNjoxNDoyMSAgIDQgLwoKVGFibGVzcGFjZSBjcmlhZG8uCgpEZWNvcnJpZG86IDAwOjAwOjMyLjU1CgoxNjoxNzoyOCBiYW5jbzE+IGNyZWF0ZSB0YWJsZXNwYWNlIGFwbGljYWNhb19pbmRleDAxCjE2OjE3OjI4ICAgMiBkYXRhZmlsZQoxNjoxNzoyOCAgIDMgJytEQVRBNC9iYW5jby9kYXRhZmlsZS9hcGxpY2FjYW9faW5kZXgwMS5kYmYnIHNpemUgNzAwMG0gYXV0b2V4dGVuZCBvbiBuZXh0IDUwMG0gbWF4c2l6ZSAxMDAwMG07CgpUYWJsZXNwYWNlIGNyaWFkby4KCkRlY29ycmlkbzogMDA6MDA6NDUuMzkKMTY6MTg6MTMgYmFuY28xPiAgICAgCjE2OjE4OjIzIGJhbmNvMT4gYWx0ZXIgdGFibGUgYXBsaWNhY2FvLlRBQkVMQV9DT01fUFJPQkxFTUEgbW92ZSBub2xvZ2dpbmcgdGFibGVzcGFjZSBhcGxpY2FjYW9fZGF0YTAxOwoKVGFiZWxhIGFsdGVyYWRhLgoKMTY6MTg6MzMgYmFuY28xPnNlbGVjdCAnYWx0ZXIgaW5kZXggYXBsaWNhY2FvLid8fGluZGV4X25hbWV8fCcgcmVidWlsZCBub2xvZ2dpbmcgdGFibGVzcGFjZSBhcGxpY2FjYW9faW5kZXgwMTsnCjE2OjE5OjUzICAgMiAgICAgICAgZnJvbSBkYmFfaW5kZXhlcwoxNjoxOTo1OCAgIDMgICAgICAgIHdoZXJlIG93bmVyID0gJ0FQTElDQUNBTycKMTY6MjA6MDQgICA0ICAgICAgICBhbmQgdGFibGVfbmFtZSA9ICdUQUJFTEFfQ09NX1BST0JMRU1BJzsKCidBTFRFUklOREVYYXBsaWNhY2FvLid8fElOREVYX05BTUV8fCdSRUJVSUxETk9MT0dHSU5HVEFCTEVTUEFDRWFwbGljYWNhb19JTkRFWDAxOycKLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KYWx0ZXIgaW5kZXggYXBsaWNhY2FvLklOREVYMSByZWJ1aWxkIG5vbG9nZ2luZyB0YWJsZXNwYWNlIGFwbGljYWNhb19pbmRleDAxOwphbHRlciBpbmRleCBhcGxpY2FjYW8uSU5ERVgyIHJlYnVpbGQgbm9sb2dnaW5nIHRhYmxlc3BhY2UgYXBsaWNhY2FvX2luZGV4MDE7CmFsdGVyIGluZGV4IGFwbGljYWNhby5JTkRFWDMgcmVidWlsZCBub2xvZ2dpbmcgdGFibGVzcGFjZSBhcGxpY2FjYW9faW5kZXgwMTsKYWx0ZXIgaW5kZXggYXBsaWNhY2FvLklOREVYNCByZWJ1aWxkIG5vbG9nZ2luZyB0YWJsZXNwYWNlIGFwbGljYWNhb19pbmRleDAxOwphbHRlciBpbmRleCBhcGxpY2FjYW8uSU5ERVg1IHJlYnVpbGQgbm9sb2dnaW5nIHRhYmxlc3BhY2UgYXBsaWNhY2FvX2luZGV4MDE7CmFsdGVyIGluZGV4IGFwbGljYWNhby5JTkRFWDYgcmVidWlsZCBub2xvZ2dpbmcgdGFibGVzcGFjZSBhcGxpY2FjYW9faW5kZXgwMTsKYWx0ZXIgaW5kZXggYXBsaWNhY2FvLklOREVYNyByZWJ1aWxkIG5vbG9nZ2luZyB0YWJsZXNwYWNlIGFwbGljYWNhb19pbmRleDAxOwphbHRlciBpbmRleCBhcGxpY2FjYW8uSU5ERVg4IHJlYnVpbGQgbm9sb2dnaW5nIHRhYmxlc3BhY2UgYXBsaWNhY2FvX2luZGV4MDE7Cgo4IGxpbmhhcyBzZWxlY2lvbmFkYXMu” hover_enabled=”0″]MTY6MTQ6MjAgYmFuY28xPiBjcmVhdGUgdGFibGVzcGFjZSBhcGxpY2FjYW9fZGF0YTAxCjE2OjE0OjIwICAgMiBkYXRhZmlsZQoxNjoxNDoyMCAgIDMgJytEQVRBNC9iYW5jby9kYXRhZmlsZS9hcGxpY2FjYW9fZGF0YTAxLmRiZicgc2l6ZSA1MDAwbSBhdXRvZXh0ZW5kIG9uIG5leHQgNTAwbSBtYXhzaXplIDEwMDAwbQoxNjoxNDoyMSAgIDQgLwoKVGFibGVzcGFjZSBjcmlhZG8uCgpEZWNvcnJpZG86IDAwOjAwOjMyLjU1CgoxNjoxNzoyOCBiYW5jbzE+IGNyZWF0ZSB0YWJsZXNwYWNlIGFwbGljYWNhb19pbmRleDAxCjE2OjE3OjI4ICAgMiBkYXRhZmlsZQoxNjoxNzoyOCAgIDMgJytEQVRBNC9iYW5jby9kYXRhZmlsZS9hcGxpY2FjYW9faW5kZXgwMS5kYmYnIHNpemUgNzAwMG0gYXV0b2V4dGVuZCBvbiBuZXh0IDUwMG0gbWF4c2l6ZSAxMDAwMG07CgpUYWJsZXNwYWNlIGNyaWFkby4KCkRlY29ycmlkbzogMDA6MDA6NDUuMzkKMTY6MTg6MTMgYmFuY28xPiAgICAgCjE2OjE4OjIzIGJhbmNvMT4gYWx0ZXIgdGFibGUgYXBsaWNhY2FvLlRBQkVMQV9DT01fUFJPQkxFTUEgbW92ZSBub2xvZ2dpbmcgdGFibGVzcGFjZSBhcGxpY2FjYW9fZGF0YTAxOwoKVGFiZWxhIGFsdGVyYWRhLgoKMTY6MTg6MzMgYmFuY28xPnNlbGVjdCAnYWx0ZXIgaW5kZXggYXBsaWNhY2FvLid8fGluZGV4X25hbWV8fCcgcmVidWlsZCBub2xvZ2dpbmcgdGFibGVzcGFjZSBhcGxpY2FjYW9faW5kZXgwMTsnCjE2OjE5OjUzICAgMiAgICAgICAgZnJvbSBkYmFfaW5kZXhlcwoxNjoxOTo1OCAgIDMgICAgICAgIHdoZXJlIG93bmVyID0gJ0FQTElDQUNBTycKMTY6MjA6MDQgICA0ICAgICAgICBhbmQgdGFibGVfbmFtZSA9ICdUQUJFTEFfQ09NX1BST0JMRU1BJzsKCidBTFRFUklOREVYYXBsaWNhY2FvLid8fElOREVYX05BTUV8fCdSRUJVSUxETk9MT0dHSU5HVEFCTEVTUEFDRWFwbGljYWNhb19JTkRFWDAxOycKLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KYWx0ZXIgaW5kZXggYXBsaWNhY2FvLklOREVYMSByZWJ1aWxkIG5vbG9nZ2luZyB0YWJsZXNwYWNlIGFwbGljYWNhb19pbmRleDAxOwphbHRlciBpbmRleCBhcGxpY2FjYW8uSU5ERVgyIHJlYnVpbGQgbm9sb2dnaW5nIHRhYmxlc3BhY2UgYXBsaWNhY2FvX2luZGV4MDE7CmFsdGVyIGluZGV4IGFwbGljYWNhby5JTkRFWDMgcmVidWlsZCBub2xvZ2dpbmcgdGFibGVzcGFjZSBhcGxpY2FjYW9faW5kZXgwMTsKYWx0ZXIgaW5kZXggYXBsaWNhY2FvLklOREVYNCByZWJ1aWxkIG5vbG9nZ2luZyB0YWJsZXNwYWNlIGFwbGljYWNhb19pbmRleDAxOwphbHRlciBpbmRleCBhcGxpY2FjYW8uSU5ERVg1IHJlYnVpbGQgbm9sb2dnaW5nIHRhYmxlc3BhY2UgYXBsaWNhY2FvX2luZGV4MDE7CmFsdGVyIGluZGV4IGFwbGljYWNhby5JTkRFWDYgcmVidWlsZCBub2xvZ2dpbmcgdGFibGVzcGFjZSBhcGxpY2FjYW9faW5kZXgwMTsKYWx0ZXIgaW5kZXggYXBsaWNhY2FvLklOREVYNyByZWJ1aWxkIG5vbG9nZ2luZyB0YWJsZXNwYWNlIGFwbGljYWNhb19pbmRleDAxOwphbHRlciBpbmRleCBhcGxpY2FjYW8uSU5ERVg4IHJlYnVpbGQgbm9sb2dnaW5nIHRhYmxlc3BhY2UgYXBsaWNhY2FvX2luZGV4MDE7Cgo4IGxpbmhhcyBzZWxlY2lvbmFkYXMu[/et_pb_dmb_code_snippet]

Houveram vários locks durante o rebuild dos indexes mas por fim todos ficaram ok.
Após o rebuild conseguimos realizar o insert:

[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”RGVjb3JyaWRvOiAwMDowMDowMC4wNgoxNjo0NTo0NyBiYW5jbzE+SU5TRVJUIElOVE8gYXBsaWNhY2FvLlRBQkVMQV9DT01fUFJPQkxFTUEoQ0FNUE8xLCBDQU1QTzIuLi4pIFZBTFVFUyAgICgxOTcwMDE0Li4uCjE2OjQ1OjU1ICAgMiAgOwoKMSBsaW5oYSBjcmlhZGEuCgpEZWNvcnJpZG86IDAwOjAwOjAwLjE3CjE2OjQ1OjU2IGJhbmNvMT5yb2xsClJvbGxiYWNrIGNvbmNsdcOtZG8u” hover_enabled=”0″]RGVjb3JyaWRvOiAwMDowMDowMC4wNgoxNjo0NTo0NyBiYW5jbzE+SU5TRVJUIElOVE8gYXBsaWNhY2FvLlRBQkVMQV9DT01fUFJPQkxFTUEoQ0FNUE8xLCBDQU1QTzIuLi4pIFZBTFVFUyAgICgxOTcwMDE0Li4uCjE2OjQ1OjU1ICAgMiAgOwoKMSBsaW5oYSBjcmlhZGEuCgpEZWNvcnJpZG86IDAwOjAwOjAwLjE3CjE2OjQ1OjU2IGJhbmNvMT5yb2xsClJvbGxiYWNrIGNvbmNsdcOtZG8u[/et_pb_dmb_code_snippet]

Nome do banco, aplicação, tabela e index alterados. Aplicação OK, cliente satisfeito e a trilha sonora no fone de ouvido era essa:

Att
Vitor Jr.