DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2001
    Hi all.
    Oracle EE , NT4.0 SP6
    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
    Brisbane, Queensland, Australia
    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
    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;


    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.