Ora-00600 When Running Alter Command

ORA-00600 When running ALTER command?

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;

Add the column as null:

ALTER TABLE testTable ADD column1 NUMBER(1);

Update values:
```
update testTable set column1 = 0;
```
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)
```

Oracle ORA-00600

Good luck with getting support from Oracle...

Seriously though, every time I hit this problem, rearranging the query a little bit usually helps. Maybe fiddling around with the indexes a bit.

Dropping table identity causes ORA-00600 error on Oracle 12c

This is a problem with Oracle 12.1.0.2.0. At least one other person has reported it (on Windows, which may be relevant).

The error you have is an ORA-00600, which is Oracle's default message for unhandled exceptions i.e. Oracle bugs. The correct answer is to raise a Service Request with Oracle Support; they will be able to provide you with a patch or a workaround if you have a corrupted table you need to fix. If you don't have a Support contract you may be out of luck.

For future reference dropping identity columns is a two-stage process:

alter table t42 modify id drop identity;

alter table t42 drop column id;

As it happens, this is not a problem on the very latest version of the product. In Oracle 18c we can just drop the column without modifying it first. LiveSQL demo.

Oracle simple update script causes ORA-00600: internal error code, arguments: [15851], [6], [6], [1], [2], [], [], []

An ORA-600 is basically a bug, ie, a program crashed and hence we bailed out.

In your case, try this:

alter session set "_complex_view_merging" = false;

and see if that solves your problem.

The real solution here - upgrade to a supported version of the database :-)

Ora-00600 When Running Alter Command