ORA-00600 while creating an Index

Error:
ORA error while executing CREATE INDEX Statement of type:
CREATE INDEX TABLE_NAME ON INDEX_NAME (COLUMN)
TABLESPACE PSDEMO STORAGE (INITIAL 40000 NEXT 100000 MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PARALLEL NOLOGGING


ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [3], [0], [16], [], [], [], []

[ or ]

ORA-12801: error signaled in parallel query server P086
ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [5], [0], [8], [], [], [], []


Steps to resolve the error:

1. SQL> alter table TABLE_NAME move;
2. Now you will be to create the index successfully.

Note: It is NOT a good idea to create index with keyword PARALLEL but no DEGREE specified. Oracle will assume "default" degree which usually is not good - too high