Pular para o conteúdo

Fóruns Banco de dados Oracle Erro ao excluir um esquema. Erro ao excluir um esquema.

#86639
David Siqueira
Participante

    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