oracle 删除表示提示错误

发布网友 发布时间：2022-04-10 20:24

我来回答

共6个回答

懂视网 时间：2022-04-11 00:45

event=‘10841 trace name context forever‘

可以屏蔽这个ORA-00600错误.

SQL> show parameter event

NAME TYPE VALUE
------------------ ----------- ------------------------------
event string 10841 trace name context forever

oracle-600错误

标签：forever   parameter   ram   text   屏蔽   string   type   trace   val   

热心网友 时间：2022-04-10 21:53

600错误是内核错误，也有可能是BUG
试着看一下错误日志，有没有什么发现吧
或者试试
1、purge recyclebin
2、 重起库并重试再删除
3、设置初始化参数"_recyclebin" = false

ORA-00600: internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]
Cause: This is the generic internal error number for Oracle program exceptions. This indicates that a process has encountered an exceptional condition.Action: Report as a bug - the first argument is the internal error number

热心网友 时间：2022-04-10 23:11

先清除recyclebin，再试着drop 表

热心网友 时间：2022-04-11 00:46

先delete 数据吧，删除了数据之后，然后drop。试一下，没见过这个，要不就重启计算机。。。然后再尝试删除，是在不行，就下个ob这个很强大的，用超级用户登陆，sys或者是system登陆删除想要删除的表。试试 ，试试 ，没见过这个错误提示。

热心网友 时间：2022-04-11 02:37

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 10.2.0.5 [Release 10.1 to 10.2]
Information in this document applies to any platform.
***Checked for relevance on 11-Sep-2013***

SYMPTOMS
You tried to drop a table and the DROP TABLE SQL command failed by raising an ORA-600 [15264].

The trace file generated at that time shows:

ORA-00600: internal error code, arguments: [15264], [], [], [], [], [], [], []
Current SQL statement for this session:
drop table ...
And Call Stack contains:
... kkdldidRecycle ...

Trying to drop the indexes may give ORA-01418: specified index does not exist.

CHANGES
The drop of the table was interrupted and then reattempted.
CAUSE
The exact cause is not all identified but this has most probably to do with the 10g recyclebin.
Bugs have been logged for similar issues, but closed with a status 'could not reproce'.

SOLUTION
Although the root cause is unknown, we suggest that you:
-> 1/ Log as sysdba and execute the following SQL command:
SQL> PURGE RECYCLEBIN;

This will purge your recycle bin and should return the following message:

Recyclebin purged.

-> 2/ Being logged as sysdba, execute now the following SQL command:
SQL> PURGE DBA_RECYCLEBIN;

This purges the DBA recycle bin and returns the following message:

DBA Recyclebin purged.

Then, you should be able to remove the table without encountering the ORA-600 [15264]

-> 3/ In other words, re-try the same operation that failed earlier:

SQL> DROP TABLE ... ;

-> 4/ If this still fails, bounce (shutdown & restart) the database and retry again the same drop command.

-> 5/ If the database bounce did not help:
in 10gR1:
set the init.ora parameter "_recyclebin" = false, bounce the database and try again the same drop.
in 10gR2
Run the following command:

SQL> ALTER SESSION SET RECYCLEBIN=OFF;
and try again the same drop.

尝试关掉 回收站 功能 可以绕过该问题

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

热心网友 时间：2022-04-11 04:45

不清楚，
重启数据库后再删除吧