-
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.
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|