ORA-02001: user SYS is not permitted to create indexes with freelist groups

ORA-02001: user SYS is not permitted to create indexes with
freelist groups

Question Posted / guest

ORA-02001: user SYS is not permitted to create indexes with freelist groups..

Answer / guest

Cause: user tried to create an index while running with sys
authorization.

Action: none

Please add more information about this Error

Is This Answer Correct ?

0 Yes

0 No

More Oracle Errors Interview Questions

ORA-39955: invalid PL/SQL warning message number

LPX-00000: normal, successful completion

CLSS-03001: local node number string, master node number string

ORA-01682: read-only DB cannot allocate temporary space in tablespace string

ORA-01323: Invalid state

ORA-14118: CHECK constraint mismatch in ALTER TABLE EXCHANGE PARTITION

ORA-02251: subquery not allowed here

ORA-13601 encountered when generating server alert SMG-3503

RMAN-08114: channel string: restoring SPFILE to PFILE

ORA-07615: $CHANGE_CLASS failed in retrieving the specified file label

IMG-00502: invalid scale value

ORA-28501: communication error on heterogeneous database link

For more Oracle Errors Interview Questions Click Here