› Fóruns › Banco de dados Oracle › Erro ao excluir um esquema. › Erro ao excluir um esquema.
Opa!!..salve todos..
Então rapaziada, acredito que eu tenha achado a razão do problema do nosso camarada, deêm uma olhada nesse texto abaixo:
Below are the twelve bugs which contain ORA-08103 in Oracle Enterprise Edition; versions 8.1 to 10.2
[i]Bug 2551000
Abstract: False ORA-1410 / ORA-8103 possible from ANALYZE COMPUTE/ESTIMATE STATISTICS
Versions affected: 8.1.7.4 & 9.2.0.3
Fixed in version: 8.1.7.5, 9.2.0.4 & 10.0
Symptoms:
To be seeing this problem the following must be true :
1) ANALYZE fails with an Ora-1403 or Ora-8103
2) The object being analyzed has a large number of extents
3) The analyze object has chained or migrated rows
4) Setting db_file_multiblock_read_count to 1 resolves the problem.
Details:
ANALYZE may report a false ORA-1410 or ORA-8103 for objects with migrated/chained rows.
Workaround:
Set db_file_multiblock_read_count=1
Patch details:
One-off patch available for few platforms on top of 8.1.7.3, 8.1.7.4, 9.0.1.3 & 9.2.0.3
Check the Metalink for Patch 2551000 availability.
[/i]
Retirei isso do seguinte link: http://www.dba-oracle.com/t_ora_08103_object_no_longer_exists.htm
Olhem e me digam o que acham, acredito que seja isso.
Abcs.
David