DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ORA-00604,ORA-00607 Please Help?

  1. #1
    Join Date
    Jun 2001
    Posts
    103
    Hi all.
    Oracle 8.1.6.0.0 EE , NT4.0 SP6
    =======================
    SQL> desc OLD_EBCREDT
    Name Null? Type
    ----------------------------------------- -------- ----------------------------
    F1 NUMBER(10)

    SQL> drop table OLD_EBCREDT ;
    drop table OLD_EBCREDT
    *
    ERROR at line 1:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-01410: invalid ROWID

    SQL> drop trigger EBCREDU;
    drop trigger EBCREDU
    *
    ERROR at line 1:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-00607: Internal error occurred while making a change to a data block
    ORA-00600: internal error code, arguments: [kcoapl_blkchk], [1], [105952],
    [6401], [], [], [], []

    What is problem ? Is error in data dictinary ?
    Is sys tables corrupted(triggers$ or objects$ ,.. )?
    ORA-00607 not exists in Oracle Error Message. Why?
    I am wait for reply.

    Best Regards.

  2. #2
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    Have you recently upgraded from an Older Oracle release
    ?


    It looks like you have Oracle Block Corruption.

    Perform a select count(*) on your table and see if that completes.
    OCP 8i, 9i DBA
    Brisbane Australia

  3. #3
    Join Date
    Jun 2001
    Posts
    103
    Hi grjohnson.
    I deleted all record from this table ,Also I revoked all privilege with this table from all users,alse i deleted all(except one) filed of this table.
    Now, Exists One table with one field and 2 trigger.
    no table and no each trigger can be deleted.
    SQL> select count(*) from OLD_EBCREDT;

    COUNT(*)
    ----------
    0

    I did'nt upgrade from older version of oracle.
    I make like table for users , but i want drop this table.
    Can you tell me which tablespace or table or object may be corrupted ?

    Best Regards.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width