ORA-00600 运行 ALTER 命令时?

问题描述

我在桌子上运行这个命令:

I am running this command on a table :

ALTER TABLE testTable ADD column1 NUMBER(1) DEFAULT 0 NOT NULL;

而且我不断收到此错误:
错误报告:
SQL 错误:ORA-00600:内部错误代码，参数:[kkpoffoc], [], [], [], [], [], [], [], [], [], [], []
00600. 00000 - "内部错误代码，参数:[%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]
*原因:这是 Oracle 程序的通用内部错误号
例外.这表明进程遇到了特殊情况.
*操作:报告错误 - 第一个参数是内部错误号

And i keep getting this error:
Error report:
SQL Error: ORA-00600: internal error code, arguments: [kkpoffoc], [], [], [], [], [], [], [], [], [], [], []
00600. 00000 - "internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]"
*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

对此有什么想法吗?

推荐答案

这是一个错误，您需要与您的 dba 交谈以制作 SR，如 paxdiablo 所说.

This is a bug, and you need to talk with your dba to make a SR as paxdiablo said.

如果时间紧迫，您可以手动执行该操作

If you are pressed for time, you can manually do what does

ALTER TABLE testTable ADD column1 NUMBER(1) DEFAULT 0 NOT NULL;

1. 将列添加为空:

1. Add the column as null:

ALTER TABLE testTable ADD column1 NUMBER(1);

更新值:

Update values:

update testTable set column1 = 0;

Alter table not null(在 precedent 和 this 之间，你必须确保没有人在表中插入):

Alter table not null(between precedent and this, you must be sure that nobody inserts in the table):

ALTER TABLE testTable MODIFY(column1  NOT NULL)

这篇关于ORA-00600 运行 ALTER 命令时?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！