创建表报错

andornot123 2011-11-30 12:05:10
在创建表的时候,
报了以下错误:
ORA-00600: internal error code, arguments: [kqlindp-bad-user], [2921], [], [], [], [], [], []
请问怎么解决呢?

操作系统:WINDOWS

ORACLE11g

...全文
138 10 打赏 收藏 转发到动态 举报
写回复
用AI写文章
10 条回复
切换为时间正序
请发表友善的回复…
发表回复
l_i_u123 2011-12-07
  • 打赏
  • 举报
回复
可能是里面的一些参数的丢失造成的
oO寒枫Oo 2011-11-30
  • 打赏
  • 举报
回复
alter日志里面?
andornot123 2011-11-30
  • 打赏
  • 举报
回复
有解决的办法吗?
iqlife 2011-11-30
  • 打赏
  • 举报
回复
不好处理,无法诊断
andornot123 2011-11-30
  • 打赏
  • 举报
回复
ORA-00600: internal error code, arguments: [kqlindp-bad-user], [2921], [], [], [], [], [], []
这个错误,
我想是因为,
emca -repos drop失败了。
但又删除了Dropping Roles/Synonymns/Tablespaces ...
而后重建又失败,
而导致的吧!

andornot123 2011-11-30
  • 打赏
  • 举报
回复
可以补充问下吗?
我再emca -repos recreate的时候,
怎么要先删除SYSMAN.MGMT_LOADER_QTABLE,
然后就是失败了。
也就是emca -repos drop失败了。
这个是为什么呢?
该怎么解决呢?
请高手指点下。
不胜感激
andornot123 2011-11-30
  • 打赏
  • 举报
回复
-- Create table
create table uyt
(
oiu varchar2(20)
)
;
就个很简单的创建表语句,肯定不会有问题的。
我心飞翔 2011-11-30
  • 打赏
  • 举报
回复
把建表语句贴一下,我们也可以测试一下啊。
huangdh12 2011-11-30
  • 打赏
  • 举报
回复
看看alert日志吧,600错误,太复杂了。
dzntree 2011-11-30
  • 打赏
  • 举报
回复
ORA-600 is an internal error generated by the generic kernel code of the Oracle RDBMS software. It is different from other Oracle errors in many ways. The following is a list of these differences:

1. An ORA-600 error may or may not be displayed on the screen. Therefore, screen output should not be relied on for capturing information on this error. Information on ORA-600 errors are found in the database alert and trace files. We recommend that you check these files frequently for database errors. (See the Alert and Trace Files section for more information.)

2. Each ORA-600 error comes with a list of arguments They usually enclosed in square brackets and follow the error on the same line for example:

ORA-00600 [14000][51202][1][51200][][]

Each argument has a specific meaning which can only be interpreted by an Oracle support analyst. The arguments may also change meaning from version to version therefore customers are not advised to memorize them.

3. Every occurrence of an ORA-600 should be reported to Oracle Support. Unlike other errors, you can not find help text for these errors. Only Oracle technical support should diagnose and take actions to prevent or resolve damage to the database.

4. Each ORA-600 error generates a database trace file.
[edit] Possible causes

Possible causes include:

time-outs,
file corruption,
failed data checks in memory, hardware, memory, or I/O messages,
incorrectly restored files
a SELECT FROM DUAL statement in PL/SQL within Oracle Forms (you have to use SELECT FROM SYS.DUAL instead!)

3,492

社区成员

发帖
与我相关
我的任务
社区描述
Oracle 高级技术相关讨论专区
社区管理员
  • 高级技术社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧